G
gknapp
I have developed an inventory for 5 products (raw matls). FIFO would b
easy if I created a separate sheet for each product. With the user i
mind, I wanted just 2 basic sheets: "Receiving Log" which maintains Qt
On-Hand and "Usage Log". As product is received an inventory code i
generated.
I would like the user to enter the product type in the "Usage Log" an
have the inventory code of the oldest product displayed to help wit
FIFO. In the "Receiving Log", I have identified the oldest inventor
code for each product but not in a predictable location - location i
dependent on the record with the oldest inventory code.
Attempts to access this code from the "Usage Log" end up with circula
reasoning. VLOOKUP doesn't work since the data is unsorted. MATC
looked promising but no luck. Aagh!!
Anyone have an idea? Thanks
easy if I created a separate sheet for each product. With the user i
mind, I wanted just 2 basic sheets: "Receiving Log" which maintains Qt
On-Hand and "Usage Log". As product is received an inventory code i
generated.
I would like the user to enter the product type in the "Usage Log" an
have the inventory code of the oldest product displayed to help wit
FIFO. In the "Receiving Log", I have identified the oldest inventor
code for each product but not in a predictable location - location i
dependent on the record with the oldest inventory code.
Attempts to access this code from the "Usage Log" end up with circula
reasoning. VLOOKUP doesn't work since the data is unsorted. MATC
looked promising but no luck. Aagh!!
Anyone have an idea? Thanks