Software

Ask something
Question Locked

Duplicating worksheets in Excel 2007

0 helpful
2 replies

by phedges

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to have two duplicate sheets on one workbook. I want to be able to make changes in sheet 1 and have those changes to automatically show up on sheet 2. How can I do that? Thanks in advance

2 replies

by thumbsup2

... all you have to do is put formulas in sheet2 which point back to cells in sheet1 so that when you change items in sheet1, everything is duplicated in sheet2.

For example, in cell A1 of sheet2, you could put the following formula:

=sheet1!A1

In cell A2 of sheet2, you would put:

=sheet1!A2

Then, continue that same type of pattern throughout the the whole of sheet2. Each cell points to it's counterpart on sheet1.

This discussion is closed to new replies.