master file

  1. J

    VBA to pull data from closed excel workbooks to Master within sub folder structures

    Hi, I have been searching for a solution to this issue for quite some time with no luck, some findings get me a portion of the way but not quite what I need. I do not have any VBA experience but I am very competent with formula writing. I need to pull data ranges from closed, excel sheets...
    • JaLoXL
    • Thread
    • closed workbooks copy & past rows vba data range master file vba & excel
    • Replies: 23
    • Forum: Excel Questions
  2. M

    Capture header rows from all Excel worksheets in a directory to a separate master file

    Hi there, I already have VBA code that will recursively trawl through a directory. I am currently using this to identify if any columns in any of the worksheets in any of the Excel workbooks within that directory contain email addresses and, if so, those columns are then deleted. Here's the...
  3. B

    Loop and match cell value in master file to file names in the folder and copy data from master file to each file in the folder

    Hi all, I just made a code to collect data from all excel sheets in one folder into one master file. I need a code to reflect any update in the master file to all files in the folder. So the code should check the column G starting from G7 and if data in G matches any file name in the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top