Hi Guys,

I have a spreadsheet, where I have identical tabs (same column widths, same titles on columns, etc), the only difference is a few values. I want to be able to flick between the sheet1 and sheet2 quickly and be in the same viewing location when I go to the other sheet.

eg: What I need is when I move from sheet1 to sheet2, for the view to be the same.

If I'm viewing sheet1 and move the screen to show ColumnG to ColumnZ, and then click on sheet2, sheet2 will show whatever sheet2 last showed. I need sheet2 to also show ColumnG to ColumnZ when I click on it; so that I can quickly determine what is different between the two sheets.

I hope that makes sense.
Thanks guys,