Hi Experts,
Need to get the below result through VBA code based on the attached sample workbook.
1. I need to copy the entire data from sheet1 into new sheet with paste special values without blanks.
2. Sheet needs to be saved on the desktop irrespecive of any user with file name based on the sheet2 cell E1.
Regards,
Anwitha
Bookmarks