Hello, I need some help in excel.
I’m working on an inventory sheet. When new inventory comes in it will be recorded in this sheet.
this is on a week by week basis that we track incoming inventory.
these tables have already been created for the rest of 2017 and contain a list of product we currently use then to the right we put the number of units recieved. When we aquire a new product that the company decides to carry how do I insert that product into what ever week we obtain it and then that auto fills into all the other rows for the rest of the year? this would have to be done by inserting a row to put the unit name in the list alpabetically and but then i need it to do the same for the other areas of product list