Excel Requirment

[Darkfighter (Code)]

Hello Everyone hope you are doing very well i have a query i hae 2 excel file so my query is i have to copy one column entire data and paste it to another excel column and also check if there any value in the 2 excel then bot shold write it from the next row
example
1 excel

2 excel

Final Output look like this on excel two is

@Anil_G @Yoichi @ashokkarale @lrtetala

[Yoichi]

Hi,

How about the following?

Sample
Sample20240903-1.zip (15.6 KB)

Regards,

[Darkfighter (Code)]

@Yoichi san actually i was working with classic activity so any idea for that

[Yoichi]

HI,

Can you try the following?

Sample
Sample20240903-1 (2).zip (15.3 KB)

Regards,

[lrtetala (Lakshman Reddy)]

Hi @Darkfighter

You can use Append Range activity

Regards,

[Darkfighter (Code)]

But the main issue is that how would bot know that he want to write on column B because in append we cant define the column name

[Darkfighter (Code)]

@Yoichi San if i use append range how can I mention that bot should write on column B ?

[Yoichi]

HI,

Can you elaborate with specific example?

Regards,

[Darkfighter (Code)]

ok so @Yoichi san
suppose this is my excel 1 sheet where i want to copy 1 particular column example-Col1
1 excel sheet

and i want to paste their all col1 data into the 2 excel sheet and bot should check if the column has any value it should write the data fom the next column
like this in the 2 excel column name (Move) so in the A2 has some value the bot paste the data rom A3

[Yoichi]

HI,

How about the following sample?

Sample
Sample20240903-1 (3).zip (16.0 KB)

This sample assumes there is no empty cell in Col1.

Regards,