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
|
|||
|
|||
Data copies automatically
When I enter data in one worksheet, it automatically appears in all
worksheets in the workbook. How do I change this??? Thanks, Sam |
#2
|
|||
|
|||
Data copies automatically
Hi Sam,
When I enter data in one worksheet, it automatically appears in all worksheets in the workbook. How do I change this??? You have grouped the worksheets (held control or shift whilst clicking their tabs). It shows because the background colour of the tabs is white. Get out of that situation by rightclicking a tab and choosing ungroup sheets. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#3
|
|||
|
|||
Data copies automatically
It sounds like your sheets are linked. If your sheet
tabs at the bottom are all white they are linked. You need to click on one that is not bold. This will unlink them Hope this helps Judith -----Original Message----- When I enter data in one worksheet, it automatically appears in all worksheets in the workbook. How do I change this??? Thanks, Sam . |
Thread Tools | |
Display Modes | |
|
|