Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Real Time Inventory at the end of day
My inventory contains 50 products with 15 to 20 different sizes, where I
manally enter the quantities in sheet 1 (on monthly bases) and then display it to a table in sheet 2. I'm trying to update the inventory on another sheet at the end of day by using two drop down list (product, size), then entering an amount that was used or added to the inventory which will point and update sheet 1. |
#2
|
|||
|
|||
so you want the drop down boxes to take you to the quantity cell of the
selected product,or???? -- paul remove nospam for email addy! "johnc" wrote: My inventory contains 50 products with 15 to 20 different sizes, where I manally enter the quantities in sheet 1 (on monthly bases) and then display it to a table in sheet 2. I'm trying to update the inventory on another sheet at the end of day by using two drop down list (product, size), then entering an amount that was used or added to the inventory which will point and update sheet 1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheets | New Users to Excel | |||
real time charting.... | Charts and Charting in Excel | |||
how to include real time & date on a worksheet | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
How do I get real time stock quotes to my excel worksheet? | Excel Discussion (Misc queries) |