DMGRealEstate
New Member
- Joined
- Sep 7, 2011
- Messages
- 2
I have 40+ reports that I generate weekly for different clients.
I have the workbook set up so that each report is in a new sheet/tab and have a macro that runs through and saves each report as a PDF using the file name I desigate in a cell within the sheet.
My clients are now wanting the reports individualy branded to them.
My thinking is that I can list each clients name, phone, website, etc. in a new sheet then develope a marco that runs through and save the reports with row 2's infomation filled in on the reports, then row 3's and so on but one I don't know how to create a marco to do that (Please help) and two they also want their logos on the reports.
Can I place an image in a cell and have it called into another cell? Can I place them all in a folder and have it call the image in based on the location and name?
Thanks for all of your help guys and gals! You always have the answers!!
I have the workbook set up so that each report is in a new sheet/tab and have a macro that runs through and saves each report as a PDF using the file name I desigate in a cell within the sheet.
My clients are now wanting the reports individualy branded to them.
My thinking is that I can list each clients name, phone, website, etc. in a new sheet then develope a marco that runs through and save the reports with row 2's infomation filled in on the reports, then row 3's and so on but one I don't know how to create a marco to do that (Please help) and two they also want their logos on the reports.
Can I place an image in a cell and have it called into another cell? Can I place them all in a folder and have it call the image in based on the location and name?
Thanks for all of your help guys and gals! You always have the answers!!