How can I set up names to automatically copy from a spreadsheet?
 

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?

How can I set up names to automatically copy from a spreadsheet?
 

right click sheet tabselect all sheetsenter desiredselect one sheet

--
Don Guillett
SalesAid Software

"John S." <John wrote in message
...
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?

How can I set up names to automatically copy from a spreadsheet?
 

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

On Sat, 30 Sep 2006 09:05:01 -0700, John S. <John
wrote:

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?