Copy Customer Data, Paste into Different Tab, Print to PDF & Save to Folder

[bartels17]

Hello All,

It's been awhile and I'm working on a new project. I am attempting to copy data from 1 tab "Master List" of a workbook "Statement of Account" into another Tab "Customer Copy" and then print "Customer Copy" tab to PDF, and Save it to a Shared Folder with the File Named "Customer Name Date" where the customer name is pulling from Cell B5 and the Date is just the current Date. It would then move onto the next customer and do the same until it reaches the end of the Master List.

Difficult? Feasible?

 

[OaklandJim]

The link below is to an Excel workbook file that does what you asked for. If the location of any data changes then you'll have to modify the code accordingly. Also, you'll have to set the variable that specifies the folder where PDFs are stored. My normal caveat applies: My code tends to be long and clunky. Someone else may come up with a better solution.

StatementSheetToPDF.xlsm