Hello
I am trying to build an inventory database in excel, I think I have the layout I need.
I need the information on the Ordered sheet to be pulled into the Received sheet when I enter the og1234 number in the Order/Ref column of the Received sheet.
So when ever I receive a delivery form suppliers I can Keep a record of it The "og1234" will change with every new order and the number of records (Items) associated with it will also differ, I also have the problem of Back orders to deal with ie if the delivered amount is less than the ordered amount and remaining stock will highlighted and closed when received on another date.
I have been reading the post here for about a month prior to this I had no excel Knowledge so there are possibly some mistakes.
I have put in sumif and vlookup if they need to be changed please feel free to do so. Thank you
Any help or advise is most welcome
Regards
mozedd.
Bookmarks