At the company I work for I am in charge of ordering seed. I have over 300 different species and I order from 10 different suppliers (ordering generally from whoever has the lowest price at the time)
I have a spreadsheet to keep track of prices but was really hoping to put together a spreadsheet to keep track of inventory.
Is there a way I can set up a group of spreadsheets to copy and paste a spacific specie to another sheet in way it will pull from the amount I have in inventory?
Any suggestions would be greatly appreciated.