Hello,
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.
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.