Excel program

[cunan]

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

 

[Otto Moehrbach]

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]

Otto,

I am not that well versed in Excel, I am teaching myself as I go. What I
have so far is a worksheet called Cut Sheet, that I enter different series
and lengths of I-Joist, Rim, and LVL. In connection with that I have a
worksheet that is called Inventory. I open the Cut Sheet and enter the
products quantity and random lengths I am shipping. As I enter these products
they are taken out of my inventory worksheet according to product, quantity,
and length. When I am finished entering the information in my Cut Sheet I
save the worksheet as a job number. This keeps my original cut sheet blank,
so I can use this sheet each time I ship a job. What I need to do is keep a
running inventory. As it is now my Inventory worksheet only gets information
from only one job number and will not keep a running inventory. I will also
need to be able to add product as I ship it into my yard. I hope I have
explained this well enough for you to understand what I am trying to do

Thanks,

Curt

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

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

 

[Otto Moehrbach]

Curt

I understand what you want to do. The devil is in the details.

You say that you have a "worksheet" called Cut Sheet. Do you
mean a workbook (file) called Cut Sheet, or do you mean just what you say, a
sheet named Cut Sheet in a file named ????

When you say you save the worksheet as a job number, do you mean
that you create a new workbook with just that one sheet in it and the
workbook is named something related to job number? Exactly where do you
place (what folder?) these job number files/sheets?

You say:

As I enter these products they are taken out of my inventory worksheet
according to product, quantity, and length.

Exactly how is this done?

I can write you some code to do all this but I need a lot of
details about the format of everything. If you wish, send me, via email, a
small file or files that you use for this as well as a job number file or
sheet. I need just the layout of everything, so if your data is proprietary
just insert fake data. Also, write down the step-by-step procedure of
everything you do as you are doing it now

My email is (e-mail address removed). Remove the "nop" from this
address. Otto

Otto,

I am not that well versed in Excel, I am teaching myself as I go. What I
have so far is a worksheet called Cut Sheet, that I enter different series
and lengths of I-Joist, Rim, and LVL. In connection with that I have a
worksheet that is called Inventory. I open the Cut Sheet and enter the
products quantity and random lengths I am shipping. As I enter these
products
they are taken out of my inventory worksheet according to product,
quantity,
and length. When I am finished entering the information in my Cut Sheet I
save the worksheet as a job number. This keeps my original cut sheet
blank,
so I can use this sheet each time I ship a job. What I need to do is keep
a
running inventory. As it is now my Inventory worksheet only gets
information
from only one job number and will not keep a running inventory. I will
also
need to be able to add product as I ship it into my yard. I hope I have
explained this well enough for you to understand what I am trying to do

Thanks,

Curt

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

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