DISPLAY TWO DIFFERENT SHEETS ON SCREEN

D

dgray138

i AM TRYING TO TRANSFER DATA FROM ONE SHEET TO ANOTHER. I CANNOT FIGURE OUT
A FORMULA TO DO THIS, SO WILL COPY MANUALLY BUT WOULD LIKE HAVE BOTH SHEETS
DISPLAYED AT ONCE ON THE SCREEN SO THE INFO IS EASILY ACCESSIBLE.
 
G

Gord Dibben

To copy data from one sheet to another by formula.........

In any cell of Sheet2 enter =Sheet1!A1 to get what's in A1

Or if you want to cut and paste go to...............

Excel 2003.....................Window>New Window

Window>Arrange>Vertical

Put a sheet in each window.

Excel 2007....................View>New Window

Arrange All>Vertical.

Put a sheet in each window.


Gord Dibben MS Excel MVP
 
Top