Import cell data into new workbook

[cabinetguy]

I have a spreadsheet that I am working on, that once an order is ready, that is created on sheet "Quote", it moves just the ordering information to another sheet, "Order Form", in the same workbook. On the "Order Form" sheet, I have a button macro that then saves that information as a pdf to be sent to the warehouse for ordering.

What I would also like this same macro button to do, that is located on the "Order Form" sheet, is to select certain cells data that is located on the "Quote" sheet in the same workbook, i.e., Job name ("Quote" C6), sale price ("Quote"H503), discount rate("Quote"G502), etc (all located on the quote sheet in various cells) ,as well as a few other cells, and copy those select cell contents into a new workbook that is located at C:\Test in a file called "Commission_Report.xlsm" into the appropriate cells. I.e., Job name from "Quote"C6 of "Quote" into C:\Test\Commission_Reports, Sheet "Commission", into the first available empty row in column "C". Sale Price goes into the same sheet, Column "D" and so on, so that for every sale, it takes the pertinent information when an order is ready to process and creates a commission report in the Commission_Report workbook.

Below is the code I use for the current PDF button macro.

Please Login or Register  to view this content.

[cabinetguy]

Is this thing on?