| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive
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!! -- jbean ------------------------------------------------------------------------ jbean's Profile: http://www.excelforum.com/member.php...o&userid=16331 View this thread: http://www.excelforum.com/showthread...hreadid=277191 |
|
#2
|
|||
|
|||
|
Hi
have a look at: http://tinyurl.com/2c62u -- Regards Frank Kabel Frankfurt, Germany "jbean" schrieb im Newsbeitrag ... 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!! -- jbean --------------------------------------------------------------------- --- jbean's Profile: http://www.excelforum.com/member.php...o&userid=16331 View this thread: http://www.excelforum.com/showthread...hreadid=277191 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions | |||
Linear Mode
