Question: how to copy whole sheet in excel to another workbook vba?
Answer: C:\Users\XXX\Documents\Target_Book. xlsx should be changed to the actual path and name of the workbook from which you want to copy a sheet.
Sheet1 should be replaced with the name of the sheet you want to copy.