I have created a spreadsheet that does recipe costing and inventory control
in one. Now I'm trying to add another component. I would like to be able to
enter the prices on the invoices that we get for various products and have
them be averaged for the entire period. I then want those averages to be
reflected in the inventory master form. The problem as I see it, is setting
up a way to enter the prices over the given period for each item. Is there a
way to possibly nest a column of cells within a sheet?
Any help would be appreciated.
Thanks