Hi guys,

I am new on this forum so please bear with me. There is this one task that I have been assigned to that I have tried to solve for some time - but just keep running into problems. I have 1 workbook with 2 sheets. The first sheet (call it sheet1) displays data. The second sheet (call it sheet 2) displays only the print area. This print area directly refers to sheet1. I basically need sheet2 to be a direct mirror sheet of the snapshot in sheet1. I cannot link it directly like (=sheet1!A1), because that does not take into consideration if I add a new row/column. I need it to directly track all changes such as when I add new columns.

I cannot make a query since it is a shared workbook. Furthermore, making absolute cells does not solve the problem either, and I have also unsuccesfully tried to make a dynamic range using the index function. Please help guys!! I have run out of stuff to try. Would really appreciate it!