Need to create a purchase order from spreadsheet info

[mjtb007]

Hi everyone. I am new to this forum, and a little green in the excel formula area. I have managed to create a spreadsheet with item description, list price, our price and total. We use this sheet to calculate our costs for doing a job. I would then like to be able to have this information automatically, or with the push of a button, send to a purchase order form. I'm sure it can be done, I just cannot figure this out. If anyone out there can help, it would be greatly appreciated. I can follow directions, if they are good ones! But have never done anything with macros or VBA before. I have tried to include a copy of the file. Obviously I would not need all of these columns to show on a po. I find all of these templates for PO's, but nowhere do they give you the ability to pull data from another source. But, ideally, i would like to be able to also price compare per vendor. One step at a time

Copy of current_eng_ABS_Fitting_List_Price_Sheet.xlsx

[nighthalcyon]

You could do something like a mail merge in MS Word where you could create your PO form. By using the data on this spreadsheet, the mail merge would fill in fields you tell it to on the PO form.