Can someone help me with this one please 
I have a spreadsheet with 2 tabs (worksheets) Tab 1 and Tab 2
I would like which ever cell I have selected in Tab 1 to be the same in Tab 2.
So as I move around to different cells in Tab 1 the same thing happens in Tab 2
Is this possible?
Many thanks in advance.

I have a spreadsheet with 2 tabs (worksheets) Tab 1 and Tab 2
I would like which ever cell I have selected in Tab 1 to be the same in Tab 2.
So as I move around to different cells in Tab 1 the same thing happens in Tab 2
Is this possible?
Many thanks in advance.