Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Control
I am trying to create an inventory system that tracks products by Lot Number.
I currently have 2 worksheets: one with inventory balances and one transaction page. I would like to be able to only input inventory changes on the transaction page and be able to see the updated balances on the balance sheet pages. The balance changes would correspond to item Lot Number so that when the lot number is typed into the transaction page, the balance page will be updated with the amount added or removed. I know this can be done because I've done it before, but it's been so long since I've had to start from scratch. Can someone help me out? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Control
You could put a formula on your balance page
=sumif(transaction page lot number column,inventory balance lot number, transaction amount column). You could do this in a separate column and then have one column for beginning balance if you also need to consider part # make a column that joins lot number and part number (lotnumber&partnumber) do this on both sheets then apply the same reasoning as above -- Crane "jahuitink" wrote: I am trying to create an inventory system that tracks products by Lot Number. I currently have 2 worksheets: one with inventory balances and one transaction page. I would like to be able to only input inventory changes on the transaction page and be able to see the updated balances on the balance sheet pages. The balance changes would correspond to item Lot Number so that when the lot number is typed into the transaction page, the balance page will be updated with the amount added or removed. I know this can be done because I've done it before, but it's been so long since I've had to start from scratch. Can someone help me out? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Control
Thank you so much! You saved my sanity!
"Crane" wrote: You could put a formula on your balance page =sumif(transaction page lot number column,inventory balance lot number, transaction amount column). You could do this in a separate column and then have one column for beginning balance if you also need to consider part # make a column that joins lot number and part number (lotnumber&partnumber) do this on both sheets then apply the same reasoning as above -- Crane "jahuitink" wrote: I am trying to create an inventory system that tracks products by Lot Number. I currently have 2 worksheets: one with inventory balances and one transaction page. I would like to be able to only input inventory changes on the transaction page and be able to see the updated balances on the balance sheet pages. The balance changes would correspond to item Lot Number so that when the lot number is typed into the transaction page, the balance page will be updated with the amount added or removed. I know this can be done because I've done it before, but it's been so long since I've had to start from scratch. Can someone help me out? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory Control | Excel Discussion (Misc queries) | |||
trying to set up inventory control sheets for wine | Setting up and Configuration of Excel | |||
Excel used for inventory control | Excel Discussion (Misc queries) | |||
How can I set up an inventory control system on Excel? | Excel Discussion (Misc queries) | |||
Inventory Control | Excel Worksheet Functions |