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.