| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Make invoice take items off stocklist in excel workbook
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
| Excel formula to make AAA-BBB equal to/consistent with BBB-AAA | Excel Worksheet Functions | |||
| How do I make a time Stamp in excel? | Excel Discussion (Misc queries) | |||
| Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
| How to make one CSV file from two Excel sheets? | Excel Discussion (Misc queries) | |||
Threaded Mode
