DISPLAY TWO DIFFERENT SHEETS ON SCREEN
 

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.

DISPLAY TWO DIFFERENT SHEETS ON SCREEN
 

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.....................WindowNew Window

WindowArrangeVertical

Put a sheet in each window.

Excel 2007....................ViewNew Window

Arrange AllVertical.

Put a sheet in each window.


Gord Dibben MS Excel MVP


On Sun, 22 Mar 2009 13:01:15 -0700,
m wrote:

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.