How do I exchanging data between worksheet and worksheet?

A

Alex7234

I'm trying to move some data from a cell to a totally different page. How do
I do that?
 
A

AlfD

Hi!

Copy and paste works between worksheets.
If you want a more permanent connection, use formulae in the secon
sheet to "draw down" data from the first.

e.g. ='Sheet1'!A2 in a cell on sheet2 will fill that cell with th
value in A2 on Sheet1
(You don't need the ' s in this case, but you will if your sheet name
have spaces in them.

Al
 
Top