Hi Everyone, I’m facing some issue in excel actions. I want to copy some specific cells from my excel and need to paste in another sheet.
My rows rage is differ from excel to excel. i will be having multiple rows data with some headers (Constant). Can anyone help me how to solve this. I’m attaching me excel sheet, In that i have mentioned my INPUT and Required OUTPUT.
Test.xlsx (11.4 KB)
Check as below
According to this you can decide the range of the rows and can use write range
It will always dynamic and search for the “Additional Plan”
Hope this will help you
Thanks
Don’t use copy/paste. Read Range the source sheet/file into a datatable, manipulate the data in the datatable if needed, then Write Range to the destination sheet/file.
Hi @Srini84 for 1 set of data it will extract but if i want another et of data means how can we extract.
i want to copy data in-between ADDITIONAL PLAN and MODERN PLAN
Repeat the same logic as lookup as Modern Plans and get the index
Hope this help you
Thanks