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.