| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel program
I have created a shipping wprkbook and a running inventory workbook that work
together. When I ship something from my shipping page I save it as a job number (200.xls in the following formula). What I need is a way for my inventory workbook to gather continuous data from all job numbers, say job 200 through 2000. I need help with the following formula in Excel: ='C:\Documents and Settings\All Users\Documents\EWP Jobs\Cut Sheets\[200.xls]INVENTORY'!$C$2. The folder with all my job numbers is called Cut Sheets. The 200.xls is one job in that folder and I need multiple jobs in this formula. Can anyone tell me how to fix this formula or maybe create a new formula? Thanks, Curt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel do this or do I need a different program? | Excel Discussion (Misc queries) | |||
| Excel program | Excel Discussion (Misc queries) | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| how to program in excel | Excel Programming | |||
| merging excel program with tdc finance program | Excel Programming | |||
Threaded Mode
