How to copy data of one Column of Excel into another Column of another Excel

Help Robot
,
1

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.)

2

Hello.

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.

Hug

3

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.

5

Thank You.!

6

Thanks Rahul!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.