Data updating in following worksheets.

Hey

theres twos ways to do this


1. Select all worksheets
2. Type formula/text etc in Cells on Sheet 1. Same content will then appear on all sheets

OR

you can also use the Auofill option on Excel to copy a series or existing data onto multiple worksheets
1. select the worksheet that contains your data or the beginning of the series of data you want to copy.
2. select the additional worksheets to copy data to
3. Select the range of cells from which you want to copy your data or the start of the series of data
4. Edit | Fill | Across worksheets.
The fill across worksheets box will then be displayed.
You then have the choice to copy All or Contents or Formulas

Hope that helps
Barbara Excel

Thanks Barbara, It's the formulas which I forget, I do not want to copy the same data into the following sheets, each sheet is set up the same but the data will increase each week as additional numbers are added to col 5 & 6; (in actual fact there will be quite a few more cols in use with different numbers going into each. Any further help and assistance you can give will be appreciated.