Hi,
I am trying to create an MRP report using Excel, but I am stuck as where to start albiet I know how I want the report to look as I have used excel MRP reports previously.
I have attached a copy of the MRP template report ‘MRP’ and a demo list of SKU’s in ‘Product Data’. So my question is how do I populate data into sheet MRP, I would like cells B2 to B6 to pull through the code in A2 from sheet ‘Product Data’? Then cells B8 to B12 to pull through the code from cell A3 from sheet ‘Product Data’ and so on.
Once I know how to do the above I can work out how to populate the other cells. I have 1000+ SKU’s and so really need to populate data automatically rather than current rheams of paper being printed and a calculator.
Thank you in advance for any help with this.
Bookmarks