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

--
isabelle

Le 2011-04-20 08:43, Skip a écrit :
> 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.

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

On Wed, 20 Apr 2011 05:43:52 -0700 (PDT), Skip <(E-Mail Removed)> wrote:

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

On Apr 20, 10:56*am, Gord Dibben <phnor...@shaw.ca> wrote:
> 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
>
>
>
> On Wed, 20 Apr 2011 05:43:52 -0700 (PDT), Skip <ssum...@live.com> wrote:
> >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.- Hide quoted text -
>
> - Show quoted text -

Thanks Gord, the dynamic vbalue is
what I needed.