Please help me out. I want to copy the template sheet format to a new sheet with existing data. Do you have any ideas? Like using hotkeys? Thanks!
Here is the template format that i wanna copy (with hidden columns).
This is a sheet i want to apply with template format.
here are the steps for you to solve hope it works:-
*open excel- give a random click in between to activate it.
these steps will unhide the columns first. After that you can copy paste.
Hi @rahul599756, Thanks for this. But i cant imagine the solution you are trying to say. Can you please give me sample WF as my reference or any screenhots of your WF? Thanks.
Please note that i just want to copy the template format (with hidden columns) to a new sheet. Thanks!
I don’t have any sample flow sorry. I was trying manually.
Please take a look . It will fix your problem.
You can use the below sample lines of code in invoke code activity
I have tried using this code to copy sheet to another workbook sheet…But am getting syntax errors for wSourece,wDestination and XLPasteSpecial as not declared…
ws and wd are workbook data types from excel application scope.
Could you please help me out
Check with below line