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.
