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.