View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonathan Jonathan is offline
external usenet poster
 
Posts: 138
Default 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.