Execl automation

I have an excel with Sheets name after city want to copy the Humidity value and display in a newly created sheet in ascending order as per city name . tried creating few steps below but didn’t worked stuck somewhere can someone guide me.

Hy @shashank_dullu,

Please check my workflow, if you have any questions please let me know

Loop_Excel_Sheets_Test.zip (36.9 KB)

Please like my post and mark my answer as solution, it helps me.


Hi @shashank_dullu ,

Here are 2 activities called “Copy to Clipboard” and “Past Clipboard” . Using these activities yo can copy-paste the value to any worksheet.

Thank you