FIFO from inventory

G

gknapp

Figured it out yesterday. It seems convoluted but it works.

I used MATCH to find the row# of the identified oldest product code.
know the column of the required inventory code. I pass this info to th
Usage Log and concatenate the name of the Receiving log with the R1C
information to provide an INDIRECT reference to the desired inventor
code. The weakness of this method is that the name of the 'Receivin
Log' sheet cannot be changed without breaking the connection.
Convoluted
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FIFO from inventory 1
FIFO from inventory 0
linking cells for auto inventory depletion 2
decrementing numbers in inventory table 2
vba to copy data from sale receipt to next available column in an inventory worksheet 0
Inventory Aging Query help? 0
=MATCH with nested arrays assistance needed 0
Randomly selecting items from a list given their statistical likelihood 0

Top