Keeping formulas that reference a tab that changes daily?

[Jonathan]

Hi all,

I have developed a worksheet that I would like to use on a daily basis to
pull numbers from a file that comes out with an updated version each day. I
would like to use the same spreadsheet (by either copying and pasting the tab
into the updated s/s or pasting the updated tab into a template) each day to
pull the updated data each day. The tab name stays the same as "Raw Data"
each day, but when I try to link it, it doesn't work and it still looks for
the original spreadsheet I used rather than just updating the numbers by
changing the data. Thanks.

 

[Pete_UK]

Instead of copy/pasting the tab, you should copy/paste the cells in
the tab to overwrite the previous days' values.

Hope this helps.

Pete

 

[Jonathan]

Yeah, that's what I was doing--just wondering if there was an easier way.
THanks.

 

[Pete_UK]

You're welcome.

Pete

Yeah, that's what I was doing--just wondering if there was an easier way.  
THanks.






- Show quoted text -