How to make a dynamic copy of a worksheet

[jankee]

I'm trying to make two identical worksheets in a workbook. I would like the second sheet reflect all the changes made in the first one. I thought I would simply use = but it doesn't work correctly if I add or delete rows. If I add a row between row 1 and 2 in the first sheet the formula in row 2 in the second worksheet changes from =sheet1!A2 to =sheet1!A3. The result is the same if I use absolute references which suprised me. I want the formula in row 2 to stay =sheet1!A2 whatever happens on the first sheet.

I don't care about formatting, just data are important.

The reason I want the same data on two worksheets is that the second sheet will contain some more data that should not be visible to everyone. I want to protect the second worksheet and require a password to unhide it.

I would be very thankful if someone had a solution to this problem.

[:) Sixthsense :)]

Do right click on sheet1 tab and select view code and paste the below code.

Please Login or Register  to view this content.

Enter value in sheet1 and check in sheet 2

[jankee]

Wow, how cool!

Unfortunatelly, I can't get it work right. If I add a row in Sheet1 a row is not added in Sheet2 - an existing row in Sheet 2 is replaced by a blank row. So I get some information missig and one less row in Sheet2. Also, it doesn't reflect the changes if I make a sort data in Sheet1.

Is there a simple fix? If not, I will look for a different way to organise my workbook.