Hello all. I've been searching this forum for a macro that will take 120 seperate workbooks and merge the data into one workbook without having to open all 120. That would blow up for sure. Each budget has a dept number as shown in yellow cell d5. The cell needs to be made a column that will copy down to all the entries in that budget and change when the next budget gets imported.
Excel Workbook
B
C
D
E
F
G
H
I
J
1
this is the original
the directory these budgets are stored in is g:\planning\2012\plan\budgets\reviewed
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.