• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Invoices from the master file


New Member

I am new to the VBA world, i need you help in coding in excel.

I have two sheets April (Contains Master data) & Sheet1 (Invoice Format)

My requirement is Just need to Copy Cell A2 from April Sheet and Paste it in Sheet 1 in Cell C6 and convert that sheet into PDF and same save the name as Value in cell C6.



Active Member
See attached.
Code to save invoice (Sheet1) as PDF.
For the first part of the question, it is impossible because you can't use / in the file name.