Feb 16 2022 05:37 AM
Hello. I am trying to combine an inventory list and a log of use (IE: user uses X g of chemicals, have the amount subtracted from the amount registered in the inventory list). How would you do this?
This is 2 separate tables (singular excel, 2 tabs). Some chemicals there are smaller containers in different locations, so I believe there would need to be an additional calculation/input for the location they were taken from.
Feb 16 2022 11:02 PM
Hi @Meghan_H
could you provide a sample file of your data, so it would be easier for us to understand and give a proper advise.