I am trying to copy a worksheet from one excel Workbook to another without changing its format or data. The workflow i currently have stops after it creates a new sheet in workbook2 and it does not transfer its contents from workbook1. Workbook1 contains links and formulas that also need to be transferred. Is there a solution for this?
Thanks for your help