How do I retrieve data (specific cells) from multiple worksheets on a shared drive

J

jbean

For example,

Joe Smoe filled in my template and told me he saved the file,
JoeSmoe.xls, in my desired shared folder (on a network). I want to
pull specific cells from his worksheet into my summary sheet by typing
in the name of his worksheet. I.e. - type JoeSmoe.xls in cell A1 and
have data from cell b2 in JoeSmoe.xls update into a specified cell in
my worksheet. Also, I would like to do this without opening his
worksheet. Does anyone know if this is possible.
Thanks!!
 

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

How to Auto Reference Worksheet Tab ID's in Formulas? 9
Copying Cell from Multiple Worksheets to a Summary Worksheet 4
lookup and worksheet name and then do formula 2
How to retrieve data from web link? 2
Reference(s) to worksheets for building graphs 4
retrieve data from different workbook 1
how do I referance a data valuation cell from another worksheet 2
Select data from two worksheets to the left 6

Top