How can I set up names to automatically copy from a spreadsheet? John S. 30.09.2006 16:05:01 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?

Re: How can I set up names to automatically copy from a spreadsheet? "Don Guillett" <dguillett1[ at ]austin.rr.com> 30.09.2006 16:25:55 right click sheet tab>select all sheets>enter desired>select one sheet -- Don Guillett SalesAid Software dguillett1[ at ]austin.rr.com "John S." <John S.[ at ]discussions.microsoft.com> wrote in message news:42FD6DC6-20FF-4579-8310-636C3FE0860C[ at ]microsoft.com... [Quoted Text] >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?

Re: How can I set up names to automatically copy from a spreadsheet? Gord Dibben <gorddibbATshawDOTca> 30.09.2006 16:46:25 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 S.[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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?