If order amount specified on product line list, pull line information to purchase order

Hello.

I cannot figure out the formula/macro to do this. Apparently I do not deserve my Microsoft Office Specialist certification!

I have two sheets in an excel workbook. The first is a product line, the second is a purchase order. If I enter an amount needed to be ordered in the first column of the product line, Id like the information to automatically fill in on the purchase order.

I also need to be able add items to the product line in this workbook without it affecting the formula/macro, and to do the same thing throughout multiple other Excel workbooks. Much appreciated.

-JeffreyPurchase Order - Design Hardware (Template).xlsx

will you run this macro once for each workbook (lets say at the end of every day), or do you plan on doing it as you go(with each purchase that you enter to the first sheet?).

Originally Posted by Bishonen

will you run this macro once for each workbook (lets say at the end of every day), or do you plan on doing it as you go(with each purchase that you enter to the first sheet?).

Every time we purchase, I will open the template and "Save As" a new document. That way the original is always in tact.

Thanks! Works like a charm!

Originally Posted by JieJenn

put this in your worksheet event. I guess that makes me a newbie since I don't have a MS Office Specialist certification

Please Login or Register  to view this content.

OK one more question... Now I am trying to add a simple sum formula to the Purchase Order to get total cost of goods being ordered. I also need to add freight charges, etc. in the space below the purchase order. Every time I enter it and go back to the product line, the formulas and text disappear. Help? I am no good with macros....

Purchase Order - Design Hardware (Template).xlsm

With macro in place throughout outlined cells, I need to be able to make changes below on the purchase order. They disappear whenever I go to product line and change "To Order" quantities.

Originally Posted by JieJenn

Post a sample file with description.

Any luck? Still trying to mess around with it to no avail....