Creating a linked file based on variable location reference

  • Thread starter Thread starter Monk
  • Start date Start date
M

Monk

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!!
 
Dear Monk

Open book2 as well as book1. Go to a cell from sheet1 of book1 where you
want the data from book2. Press + on your keyboard and select the cell from
book2 (where you have the desired data) then press enter. Link will be
created automatically which can be edited later using Edit - Links
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent List Box Reference from Changing when workbook closes? 3
Cell Reference on a different sheet 3
Linked Cells, Increment Sheet Number Ref. 3
some kind of meta-way to refer to sheet and file names in Excel? 7
Dynamic referencing to files 4
Correction 2
When calling a different file, can I make the tab equal to a cell? 1
Very very basic macro help 2

Back
Top