copying data from folder to folder
 

I have folders on a server, one folder for each branch office. Within each
branch folder, I have several folders labeled Warehouse, etc.. In the
warehouse folder, I have several excel workbooks (one for each month, etc.),
each comprised of 8 to 10 worksheets.

If I add lines in one branch warehouse worksheet, can I have the other
branch warehouse worksheets set up to copy that data? TIA

copying data from folder to folder
 

You can have a "Master" workbook
Then link the others to that one, so it can be updated when opened.

"RPW" wrote:

I have folders on a server, one folder for each branch office. Within each
branch folder, I have several folders labeled Warehouse, etc.. In the
warehouse folder, I have several excel workbooks (one for each month, etc.),
each comprised of 8 to 10 worksheets.

If I add lines in one branch warehouse worksheet, can I have the other
branch warehouse worksheets set up to copy that data? TIA