K
Kathy Powercraft
Hi all,
I have used sheet 1 of my workbook to enter stock details, stock no price
etc. Have used Vlookup function in Invoice on Sheet 2 of the workbook to
automate the invoice to bring in description and price from sheet 1. I would
like the invoice on sheet 2 to then take items out of amount of stock on hand
on the stocklist sheet as invoices are completed.
On the invoice the Quantity column is column 1 of sheet 2 A11:A17, stock
number is column 2 B11:B17, Sheet 1 stocklist is A2:n240, stock numbers are
in column 1 and the units sold column is 13 (M) and the total in stock column
is column 12 (L).
I thought maybe using Vlookup but with somehow making it add to units sold
column and then a formula within the total stock column and units sold column
to adjust the figures.
Can anyone help with this?
Thanks
Kathy
I have used sheet 1 of my workbook to enter stock details, stock no price
etc. Have used Vlookup function in Invoice on Sheet 2 of the workbook to
automate the invoice to bring in description and price from sheet 1. I would
like the invoice on sheet 2 to then take items out of amount of stock on hand
on the stocklist sheet as invoices are completed.
On the invoice the Quantity column is column 1 of sheet 2 A11:A17, stock
number is column 2 B11:B17, Sheet 1 stocklist is A2:n240, stock numbers are
in column 1 and the units sold column is 13 (M) and the total in stock column
is column 12 (L).
I thought maybe using Vlookup but with somehow making it add to units sold
column and then a formula within the total stock column and units sold column
to adjust the figures.
Can anyone help with this?
Thanks
Kathy