inventory invoice
 

Is there an easier way to adjust inventory on a daily basis other than using
VLOOKUP?
I currently have invoice, inventory, and price pages on seperate sheets and
just copy and paste items into invoice.
I would love to have inventory adusted daily if possible (and simply)
Any help is greatly appreciated.
Thanks
Michelle

inventory invoice
 

You really need to show us your data layout on all the sheets and what you
want the results to look like.

Without that I suggest you look at the sample inventory templates at:

http://office.microsoft.com/en-us/te...172541033.aspx


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Michelle" wrote:

Is there an easier way to adjust inventory on a daily basis other than using
VLOOKUP?
I currently have invoice, inventory, and price pages on seperate sheets and
just copy and paste items into invoice.
I would love to have inventory adusted daily if possible (and simply)
Any help is greatly appreciated.
Thanks
Michelle

inventory invoice
 

Shane, thanks for your reply.
We have set up 1 workbook with sheets titled Customers-Invoice-Prices-and 4
sheets for inventory (could be put on 1 sheet if necessary, total about 120
items)

We copy and paste the customer address into the invoice.

In order to simplifiy copy & paste our price pages and invoice are
structured the same.
A B C D E
F G
item code -blank space (for qty)-prod descptn-size-case pack-price - total

only formula entered is g=b x f and a auto sum grand total at bottom of col g.

None of the items listed are sorted or in any alpha order.

We currently manually enter/adjust inventory levels, on a per product basis
on their individual sheets.
The inventory sheets in the workbook are not used daily, they are just a
listing with qrtly qty's. I would like to change it so the inventory sheets
could give us upto date qty levels. Adjusted as products get invoiced out.
Not sure how to handle taxes or shipping charges either ( I guess just
manually at bottom of invoice as we have been doing?)

I found another thread that talked about VLOOKUP, and I tried many formulas
but find it frustrating and too involved (since we are used to such a simple
system right now).They set it up so the product code was entered and the full
description came up on the invoice. And later somehow made up a formula to
reduce inventory as the item gets invoice.



"Shane Devenshire" wrote:

You really need to show us your data layout on all the sheets and what you
want the results to look like.

Without that I suggest you look at the sample inventory templates at:

http://office.microsoft.com/en-us/te...172541033.aspx


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Michelle" wrote:

Is there an easier way to adjust inventory on a daily basis other than using
VLOOKUP?
I currently have invoice, inventory, and price pages on seperate sheets and
just copy and paste items into invoice.
I would love to have inventory adusted daily if possible (and simply)
Any help is greatly appreciated.
Thanks
Michelle

inventory invoice
 

looks all jumbled up.
Set up as follows;
A-item code B-Blank space (for qty) C-Desrpt'n D-Size E-Case pk F-price
G-total

"Michelle" wrote:

Shane, thanks for your reply.
We have set up 1 workbook with sheets titled Customers-Invoice-Prices-and 4
sheets for inventory (could be put on 1 sheet if necessary, total about 120
items)

We copy and paste the customer address into the invoice.

In order to simplifiy copy & paste our price pages and invoice are
structured the same.
A B C D E
F G
item code -blank space (for qty)-prod descptn-size-case pack-price - total

only formula entered is g=b x f and a auto sum grand total at bottom of col g.

None of the items listed are sorted or in any alpha order.

We currently manually enter/adjust inventory levels, on a per product basis
on their individual sheets.
The inventory sheets in the workbook are not used daily, they are just a
listing with qrtly qty's. I would like to change it so the inventory sheets
could give us upto date qty levels. Adjusted as products get invoiced out.
Not sure how to handle taxes or shipping charges either ( I guess just
manually at bottom of invoice as we have been doing?)

I found another thread that talked about VLOOKUP, and I tried many formulas
but find it frustrating and too involved (since we are used to such a simple
system right now).They set it up so the product code was entered and the full
description came up on the invoice. And later somehow made up a formula to
reduce inventory as the item gets invoice.



"Shane Devenshire" wrote:

You really need to show us your data layout on all the sheets and what you
want the results to look like.

Without that I suggest you look at the sample inventory templates at:

http://office.microsoft.com/en-us/te...172541033.aspx


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Michelle" wrote:

Is there an easier way to adjust inventory on a daily basis other than using
VLOOKUP?
I currently have invoice, inventory, and price pages on seperate sheets and
just copy and paste items into invoice.
I would love to have inventory adusted daily if possible (and simply)
Any help is greatly appreciated.
Thanks
Michelle

inventory invoice
 

Does this make sense to anyone?
thnx

"Michelle" wrote:

looks all jumbled up.
Set up as follows;
A-item code B-Blank space (for qty) C-Desrpt'n D-Size E-Case pk F-price
G-total

"Michelle" wrote:

Shane, thanks for your reply.
We have set up 1 workbook with sheets titled Customers-Invoice-Prices-and 4
sheets for inventory (could be put on 1 sheet if necessary, total about 120
items)

We copy and paste the customer address into the invoice.

In order to simplifiy copy & paste our price pages and invoice are
structured the same.
A B C D E
F G
item code -blank space (for qty)-prod descptn-size-case pack-price - total

only formula entered is g=b x f and a auto sum grand total at bottom of col g.

None of the items listed are sorted or in any alpha order.

We currently manually enter/adjust inventory levels, on a per product basis
on their individual sheets.
The inventory sheets in the workbook are not used daily, they are just a
listing with qrtly qty's. I would like to change it so the inventory sheets
could give us upto date qty levels. Adjusted as products get invoiced out.
Not sure how to handle taxes or shipping charges either ( I guess just
manually at bottom of invoice as we have been doing?)

I found another thread that talked about VLOOKUP, and I tried many formulas
but find it frustrating and too involved (since we are used to such a simple
system right now).They set it up so the product code was entered and the full
description came up on the invoice. And later somehow made up a formula to
reduce inventory as the item gets invoice.



"Shane Devenshire" wrote:

You really need to show us your data layout on all the sheets and what you
want the results to look like.

Without that I suggest you look at the sample inventory templates at:

http://office.microsoft.com/en-us/te...172541033.aspx


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Michelle" wrote:

Is there an easier way to adjust inventory on a daily basis other than using
VLOOKUP?
I currently have invoice, inventory, and price pages on seperate sheets and
just copy and paste items into invoice.
I would love to have inventory adusted daily if possible (and simply)
Any help is greatly appreciated.
Thanks
Michelle