Copying a cell value from one page to another

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

I need to copy a cell value on page 3 of a workbook to a cell on
page 1. Is this possible? Any help is appreciated.
 
hi,

select the cell of page 1, enter the = sign and then with the mouse,
select page 3 and the cell that you need the value and press enter.

or

select cell on page 3 and then right click on mouse and select "copy"
select cell of page 1 and then right click on mouse and select "paste special" and "values​​"
 
Workbooks don't have pages.

Do you mean worksheet 1 and worksheet2?

Simply copy the cell from sheet3 and paste to sheet1

If you want a dynamic value, enter =sheet3!a1 in a cell on sheet1


Gord Dibben MS Excel MVP
 
Workbooks don't have pages.

Do you mean worksheet 1 and worksheet2?

Simply copy the cell from sheet3 and paste to sheet1

If you want a dynamic value, enter =sheet3!a1  in a cell on sheet1

Gord Dibben     MS Excel MVP





- Show quoted text -
Click to expand...

Thanks Gord, the dynamic vbalue is
what I needed.
 
Back
Top