How to copy data of particular column of one excel (Data can be in any range e.g. A3 to A6, A3 to A45 i.e. dynamic range) into another column of another excel (e.g. range starting from A4 or A6 etc.)
You can user “Filter Data Table” Activity to filter yhe column that you want (if you know the column name).
The output is a datatable.
Write range to write on the other excel.
Hello @Rohit_Patil1 You can use read range and write range activity to achieve this. but the range of the both the activities needs to be dynamic based on the condition. So you can use dynamic variables to change the values of the range.