Macro to Pull Info from Product Line Sheet to Purchase Order Sheet

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

Also, "Our Cost" in the Product Line worksheet equals "Unit Cost" in the Purchase Order worksheet.

Also, I am using Excel 2010... Not sure why it says Excel 2003

Thanks MarvinP, it works great! I appreciate it!

I have three different worksheets I need to apply the same VBA in to. I copied/pasted values and everything seemed to work properly, but then it wouldnt let me save the file. Does it need to be set up individually?

Originally Posted by MarvinP

HI JeffreyJr,

Find the attached with VBA code that does a lot of what you need. It isn't perferfect but will give you a start in your learning VBA.