Copy data from worksheet to another automatically

  • Thread starter Thread starter kbear
  • Start date Start date
K

kbear

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
 
Thank you, that worked perfectly.

Gary''s Student said:
Without VBA we can use links

In Sheet1, cells A1 thru A3:

=Sheet3!A1
=Sheet3!A2
=Sheet3!A3
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top