Duplicating worksheets in Excel 2007

By phedges ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

I'm not sure what the purpose would be, but....

by ThumbsUp2 In reply to Duplicating worksheets in ...

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


In cell A2 of sheet2, you would put:


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

Related Discussions

Related Forums