Automatic Update of Linked Cell References

  • Thread starter Joseph Wechselberger
  • Start date


Joseph Wechselberger

I use Windows XP, Excel 2003 on one computer; and Windows Vista, Excel 2007,
on another one. This question refers to both operating systems and Excel

I maintain detailed Excel spreadsheets that contain cumulative information
to which daily data are posted (referred to as Report A). Report A data are
linked to another spreadsheet (Report B) that reports only the most recent
daily data. Each day, I have to manually update the references on Report B so
the data for that day from Report A can post. This is tedious and time
consuming. I have searched for solutions to my problem, but with no success.
Is there any way I can have the references on Report B automatically
increment each day to preclude my manually having to do it?



Luke M

A lot depends on how you've got things structured, but a place to start might
be to look at using the TODAY() function to help determine what date Report B
should be looking for, and tie that into Report A using either INDIRECT or
MATCH (again, depends on layout of your reports)


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