I have a spreadsheet that has 42 tabs, 1 for each week. I want to be able to
enter names on lines in the 1st tab and them automatically enter on the same
corresponding line on each additional tab. Each tab contains the exact same
spread sheet. Can this be done?
Don Guillett - 30 Sep 2006 17:25 GMT
right click sheet tab>select all sheets>enter desired>select one sheet

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>I have a spreadsheet that has 42 tabs, 1 for each week. I want to be able
>to
[quoted text clipped - 3 lines]
> same
> spread sheet. Can this be done?
Gord Dibben - 30 Sep 2006 17:46 GMT
If a one-time operation..............
Select first sheet tab the right-click and "select all sheets"
Assuming list of names to go into A1:H1
Enter your list of names on the active sheet and will be done to all sheets.
DO NOT FORGET to right-click and ungroup the sheets or click on any sheet but
the active one to ungroup.
If an ongoing operation, you will have to link each sheet to the first sheet.
Select second sheet and SHIFT + click on last sheet to select all but first
sheet.
Select A1 on the active sheet and enter =Sheet1!A1 then drag/copy across to H1
Ungroup the sheets.
Gord Dibben MS Excel MVP
>I have a spreadsheet that has 42 tabs, 1 for each week. I want to be able to
>enter names on lines in the 1st tab and them automatically enter on the same
>corresponding line on each additional tab. Each tab contains the exact same
>spread sheet. Can this be done?