Copy CellValue from changing Cell no and paste paste it to another excel

[AsitabhaDeb]

Hi Experts,

I have two excel file, I need to copy cell value (Order Receive Date = mm/dd/yyyy) from Source Excel file, where cell no is keep changing and the paste that cell value to another excel.

In the Destination excel file there are list of Sales Order#. For every Sales order when I copy data from another excel the data will be (Order Receive Date = mm/dd/yyyy) format but cell no will be change for next Sales order# in Source Excel File.

For Sales Order = 123456-100 Order Received Date = 01/01/2020 Cell NO = B2 - Source Excel File
For Sales Order = 123456-200 Order Received Date = 01/01/2020 Cell NO = B3 - Source Excel File

------------------------------
Asitabha Deb
------------------------------

[NileshJadhavBP]

Hi Asitabha

You can get both excel data into the collection.and match as per your the data as per requirement

use write collection action to print final data into excel.

Thanks


------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------