Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Updating several sheets from 0ne sheet
I have 500 excel files all containing the same template which shows the week
by week sales of individual styles of stock. The template cotains a list of week dates throughout the year and details of the stock. Is there a way that I could change the dates on my template file and have all the other files automatically update themselves from this one file. |
#2
|
|||
|
|||
"Insideout designs of the mind" wrote: I have 500 excel files all containing the same template which shows the week by week sales of individual styles of stock. The template cotains a list of week dates throughout the year and details of the stock. Is there a way that I could change the dates on my template file and have all the other files automatically update themselves from this one file. I don't know about a template but you can refer to a single workbook with a formula. If a date is in sheet3 of book1 then =[Book1]Sheet3!E$1 will show the same date. You will be asked if your want to update the links when the other file(s) is opened. Regards Peter Atherton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a single sheet from many sheets | Excel Worksheet Functions | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |