If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
i want to edit the same information in ten different files
I have 20 different worksheets. Each week I want to change the date in all
the worksheets. Is there an easier way than to individually change each and every worksheet. I am very new to excel so simple instructions would be great. |
#2
|
|||
|
|||
Us a formula that points back to the one primary cell:
A formula like: ='sheet 1'!a1 or even =if('sheet 1'!a1="","",'sheet 1'!a1) If the cells on each worksheet have the same address, you could group those sheets (select the first and ctrl-click on the subsequent worksheet tabs). Then just change it once. But be careful. Any change you make to any of these grouped sheets will be made to all the sheets in the group. Just rightclick on one of the grouped sheets and select ungroup sheets when you're done. (Excel tries to remind you by adding [Group] in the title bar.) caroline wrote: I have 20 different worksheets. Each week I want to change the date in all the worksheets. Is there an easier way than to individually change each and every worksheet. I am very new to excel so simple instructions would be great. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
display information based on cell input | jlm661 | General Discussion | 1 | July 30th, 2004 01:19 PM |
Edit Form. Need help | Le Tran | New Users | 4 | June 18th, 2004 10:51 PM |
Edit table using union query | De'Ville | Running & Setting Up Queries | 1 | June 1st, 2004 11:46 AM |
Subform is unable to edit using edit command button | Chuck | Using Forms | 0 | May 26th, 2004 11:26 PM |