Copy "Sheet1" from workbook1 to "sheet1" workbook2

[manish_patel]

Hi

i want to copy a sheet from workbook1 and add them into workbook2
in destination sheet all formula and format should contain as it is in workbook1

how can i solve this
please help

my excel file extention is .xlsb

[THIRU_NANI (NaNi)]

Hi! Welcome to community!

Have a view on this

Copy Sheet

Regards,
NaNi

[Srini84 (Srinivas Kadamati)]

@manish_patel

As @THIRU_NANI suggested you can use Copy Sheet

Hope this will help you

Thanks

[Shikhar_Tandon]

Hi @manish_patel ,

you can use Copy Sheet activity as suggested above, or use a Vb script in a invoke code or invoke vba activity to copy sheet to other file.

Thanks