Good morning,

I am looking for a macro. When I add a quantity in the "To Order" column of the Product Line Sheet (range A5:H40), I want it to pull all required information into the Purchase Order Sheet (range A15:F46). I do not want the macro to interfere with the "Total Cost" formula (F48) at the bottom of the Purchase Order worksheet.

It will make a lot more sense if you view the attached file. it's a pretty basic worksheet. Please either give me a fish or teach me how to fish, whichever works best for you! Thanks!

Purchase Order Template.xlsx