I've created an Excel file that has a bunch of tabs for different things. One is my Bill of Materials. I was trying to create a 2nd Excel file that would be my Purchase Request form without all the unnecessary tabs to make it stream lined for my purchaser. I know how to point to another file and make it work. What I was wondering is if there is a way to create a blank form and be able to type in just the reference file name in a single block and that would repoint all the formulas to the proper location.
='[xxx Internal Cost REV0.xlsx]Tab1'!$A$31 Is doing it the normal way
I want to use an unused cell that I would type the actual new file name into to replace "xxx Internal Cost REV0.xlsx"
So I was picturing something like:
and cell Z3 I would type in "xxx Internal Cost REV0.xlsx"