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
|