DISPLAY TWO DIFFERENT SHEETS ON SCREEN

  • Thread starter Thread starter dgray138
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Two Instances 3
Finding a specific item between two sheets. 2
Calculate data from different sheets 4
slow screen build-up 1
displaying specific rows on screen 1
VBA to automatically cut, paste entire row based on date input and delete row 0
Newbie for starters with excel, I am needing to transfer info fromsheet2 to the universe sheet. 1

Back
Top