information automatically changes

B

Blythe PD

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.
 
A

Ashish Mathur

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
 
D

Dennis Tucker

Instead of copy and paste of the data, try copying the worksheet. See the
attached image.


Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top