Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John S. - 30 Sep 2006 17:05 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.