| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
information automatically changes
I created a workbook to chart payroll. Because the pages are all essentially
the same, I copied the first page several times to create the other pages. In some boxes, when I enter the information on any of the sheets, it automatically changes the info in the same box on all of the other sheets. How can I change this? I didn't insert any macros or anything into this book. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
information automatically changes
Hi,
The worksheets are all grouped. Toungroup, right click on the tab of any of the worksheets and select "Ungroup sheets" -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Blythe PD" <Blythe wrote in message ... I created a workbook to chart payroll. Because the pages are all essentially the same, I copied the first page several times to create the other pages. In some boxes, when I enter the information on any of the sheets, it automatically changes the info in the same box on all of the other sheets. How can I change this? I didn't insert any macros or anything into this book. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
information automatically changes
Instead of copy and paste of the data, try copying the worksheet. See the
attached image. Dennis "Blythe PD" <Blythe wrote in message ... I created a workbook to chart payroll. Because the pages are all essentially the same, I copied the first page several times to create the other pages. In some boxes, when I enter the information on any of the sheets, it automatically changes the info in the same box on all of the other sheets. How can I change this? I didn't insert any macros or anything into this book. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically copy contact information? | Excel Discussion (Misc queries) | |||
| Automatically changing cell information | Excel Discussion (Misc queries) | |||
| how do you have information from one tab automatically populate i | Excel Worksheet Functions | |||
| How can I have information from a form I created to automatically. | Excel Discussion (Misc queries) | |||
| how can i automatically copy the information in one cell on a she. | Excel Worksheet Functions | |||
Hybrid Mode
