I would like to have data from one worksheet automatically populate another
worksheet. There are just 3 cells. I am using Excel 2003.
any help would be appreciated.
Thank you.

Without VBA we can use links

In Sheet1, cells A1 thru A3:

=Sheet3!A1
=Sheet3!A2
=Sheet3!A3

--
Gary''s Student - gsnu200768


"kbear" wrote:

> I would like to have data from one worksheet automatically populate another
> worksheet. There are just 3 cells. I am using Excel 2003.
> any help would be appreciated.
> Thank you.

Thank you, that worked perfectly.

"Gary''s Student" wrote:

> Without VBA we can use links
>
> In Sheet1, cells A1 thru A3:
>
> =Sheet3!A1
> =Sheet3!A2
> =Sheet3!A3
>
> --
> Gary''s Student - gsnu200768
>
>
> "kbear" wrote:
>
> > I would like to have data from one worksheet automatically populate another
> > worksheet. There are just 3 cells. I am using Excel 2003.
> > any help would be appreciated.
> > Thank you.

I am unable to get the data to update. I am entering new data in the sheet
once a week, so how do I get the formula-which will be in a new cell on the
other sheet each week-to update when I enter data?
thanks.

"kbear" wrote:

> Thank you, that worked perfectly.
>
> "Gary''s Student" wrote:
>
> > Without VBA we can use links
> >
> > In Sheet1, cells A1 thru A3:
> >
> > =Sheet3!A1
> > =Sheet3!A2
> > =Sheet3!A3
> >
> > --
> > Gary''s Student - gsnu200768
> >
> >
> > "kbear" wrote:
> >
> > > I would like to have data from one worksheet automatically populate another
> > > worksheet. There are just 3 cells. I am using Excel 2003.
> > > any help would be appreciated.
> > > Thank you.