Keeping formulas that reference a tab that changes daily?
 

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.

Keeping formulas that reference a tab that changes daily?
 

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

On Jan 10, 3:47*pm, Jonathan
wrote:
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.

Keeping formulas that reference a tab that changes daily?
 

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

"Pete_UK" wrote:

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

On Jan 10, 3:47 pm, Jonathan
wrote:
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.

Keeping formulas that reference a tab that changes daily?
 

You're welcome.

Pete

On Jan 10, 4:09*pm, Jonathan
wrote:
Yeah, that's what I was doing--just wondering if there was an easier way. *
THanks.



"Pete_UK" wrote:
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

On Jan 10, 3:47 pm, Jonathan
wrote:
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.- Hide quoted text -

- Show quoted text -