View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken
 
Posts: n/a
Default Referencing a different Workbook

I have a workbook that references different sheets in a different workbook.
But when I start a new project I must update all the references with the new
filenames using "Replace".

Is it possible to enter the new filename into a cell and just have all my
references point to that cell instead of directly to the other workbook?

Thanks for any help!

Ken