Blue Prism Product

last person joined: 10 hours ago 

Chat about Blue Prism products
Expand all | Collapse all

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

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

    Posted 11-25-2020 03:02
    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
    ------------------------------


  • 2.  RE: Copy CellValue from changing Cell no and paste paste it to another excel

    Posted 11-26-2020 14:53
    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
    ------------------------------



Share