| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching for info in a separate workbook
Bear with me on this...I have a worksheet that contains post office
information. Certain offices are tagged with having certain workhour functions that others don't. If the office has the targeted function within it, I need it to go to a workbook in a different location to find the specific amount of hours used for that function and return the value to the original sheet. For instance, if the office ZIP code were "40205", I would need it to find a file called "40205_3998X.xls" in another location and go to the sheet and find the amount of workhours in a particular function. Complicated, I know. But doable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Use info in separate table file | Excel Discussion (Misc queries) | |||
| Distribute info from "summary" page to separate pages under condition | Excel Worksheet Functions | |||
| Excel Column-Can I separate info within a cell? | Excel Discussion (Misc queries) | |||
| Adding rows of different info from separate worksheets into summar | New Users to Excel | |||
Linear Mode
