Curt
A formula is not going to do what you want, you will need VBA. To help
you with a VBA project to do this, you have to provide more information.
Specifically:
You say you have a shipping workbook.
You say you ship something from that shipping workbook.
You say that when you ship something, you save that job as a separate
workbook with the job number in the name.
How do you now create that separate workbook for that job? In detail.
You say you have an inventory workbook and you want data from the new job
workbook to be placed in this inventory workbook.
Is all the above correct?
If so, then I suggest something like the following:
Place code (a macro) in the shipping workbook.
When you are through doing what you do to ship something, you activate the
code.
The code copies what you want to the inventory workbook.
The code creates the new job workbook.
Done.
Post back if you think something like this will work for you. A lot of
detail format data will be needed from you regarding sheets, columns, rows,
and cells to copy from this workbook to that workbook as well as the full
paths to the separate workbooks. HTH Otto
"cunan" wrote in message
...
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