Thread: Creating a linked file based on variable location reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Monk[_2_] Monk[_2_] is offline
external usenet poster
  
Posts: 65
Default Creating a linked file based on variable location reference
In Book1, cell z1, I have a file location reference (F:\Home\Paul\Book2.xls)
which can change via vlookup depending on the name of the saleperson. I want
the data from Sheet 1 of that z1 file location to appear in Sheet 1 of Book1.

What formula or macro would I need to put in (Book1 Sheet 1) to pick up data
from the location and file name from cell z1?

Sorry if the above is confusing!!
Reply With QuoteReply With Quote