Hi all
I would like to create a Macro which does the following task.
I have a Workbook Master.xlsx with a worksheet "source"
The path of Master.xlsx is C:\Test
In the Directory C:\Test\projects i have about 50 files which all contain the String "Forecast" in their filename.
These Forecast Workbooks need an update in the Worksheet "actuals"
So, i need a Macro that copies WS "source" from WB "Master" to WS actuals in all WB's Forecast.
Can you help me, im new with VBA....
Thanks in advance
Pascal
Bookmarks