Hey,
I have the following problem: I have made 2 documents that are linked with Vlookup. The first one with all the variables we will call VAR1 and the other one with all the Vlookup formulas, we will call Lookup1.
I want to copy all the formulas from Lookup1 to a new file, lets say Lookup2, but then Lookup2 is still linked to VAR1 so I want to create a new document VAR2 and link automatically all formulas from Lookup2 to VAR2.
Can you help me out?
Regards
Bookmarks