Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a file which serves as a master template. Over time, I have used this
for several workbooks which contain financial data on companies, and therefore now have over 100 different workbooks based off this template. The problem now is that the master template had to be updated, and I need the changes to be reflected in each of the workbooks saved under the old template. The updates that need to be made are fairly simple, and mostly include new values or formulas in cells. What I would like to do is have the master template workbook open, and then have some code that will go through all workbooks in a directory one by one, open each workbook, and copy certain certain cells (let's assume Cell A1 on Worksheet 1 and Cell B2 on Worksheet 2 for this example) from the master template to the old file with the outdated template. Is this difficult to do. I would appreciate any code that could be provided to accomplish this. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UPDATING LINKS TO OTHER WORKBOOKS :( | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Updating multiple linked workbooks | New Users to Excel | |||
Updating linked workbooks | Excel Discussion (Misc queries) | |||
Updating Old Workbooks | Excel Worksheet Functions |