LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 367
Default Updating Multiple Workbooks

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UPDATING LINKS TO OTHER WORKBOOKS :( Dan Excel Discussion (Misc queries) 5 February 22nd 09 09:58 PM
Updating Workbooks from multiple links Workbooks TimJames Excel Worksheet Functions 1 December 15th 07 03:34 PM
Updating multiple linked workbooks dk New Users to Excel 1 June 9th 06 12:33 AM
Updating linked workbooks Michael Rekas Excel Discussion (Misc queries) 1 August 15th 05 01:42 PM
Updating Old Workbooks Paulie Excel Worksheet Functions 0 March 1st 05 07:11 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"