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.

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.

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.