How to select next column and write into it in Excel

Help
1

Hi Team
How to find next column and copy the data present in the last column.
Example : Data present in column A should copy to B if I run once and for next run B to C column and so on

Book1.xlsx (11.6 KB)

2

Hi @NITHIN_CH
Use Excel application scope activity and use select range “a1:a100” use send hot keyctrl+c and use send hot key ctrl+v use excel application scope

Thanks
ashwin S

3

Hi @AshwinS2

Thanks For reply.
Your Method is static way, Where every time I have to change the target where I have to paste, But my requirement is dynamic way, It should automatically look for last column in the table(DT) and copy it and paste to the next column.

4

Hi @NITHIN_CH

Uncheck add headers and then try to write the datatable in write range activity

Thanks
Ashwin S

5

@NITHIN_CH
u got solution on that query?

6

Hi @monikanimbalkar
Nope. I didn’t get Solution