Copying a cell value from one page to another

[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.

 

[isabelle]

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​​"

 

[Gord Dibben]

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

 

[Skip]

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 -

Thanks Gord, the dynamic vbalue is
what I needed.