https://community.blueprism.com/t5/Product-Forum/Copy-CellValue-from-changing-Cell-no-and-paste-paste-it-to/m-p/59536#M13162 Hi <A id="MainCopy_ctl10_ucMessageList_rptMessageList_ProfileImageDisplay_0_NameLink_0" biobubblekey="f18e4bb4-b698-44a7-bcf3-41fd9b0a8ebe" href="https://community.blueprism.com/network/profile?UserKey=f18e4bb4-b698-44a7-bcf3-41fd9b0a8ebe" target="_blank" rel="noopener">Asitabha</A><BR /><BR />You can get both excel data into the collection.and match as per your the data as per requirement<BR /><BR />use write collection action to print final data into excel.<BR /><BR />Thanks<BR /><BR /><BR />------------------------------<BR />Nilesh Jadhav <BR />Senior RPA Specialist<BR />ADP<BR />India<BR />------------------------------<BR /> Thu, 26 Nov 2020 19:53:00 GMT NileshJadhavBP 2020-11-26T19:53:00Z https://community.blueprism.com/t5/Product-Forum/Copy-CellValue-from-changing-Cell-no-and-paste-paste-it-to/m-p/59535#M13161 <SPAN style="color: #000080;"><STRONG>Hi Experts,</STRONG></SPAN><BR /><BR /><SPAN style="color: #000080;"><STRONG>I have two excel file, I need to copy cell value (<SPAN style="text-align: left; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Nunito Sans',sans-serif; font-size: 14px; font-style: normal; font-variant: normal; text-decoration: none; word-spacing: 0px; display: inline !important; white-space: normal; cursor: text; orphans: 2; float: none; -webkit-text-stroke-width: 0px; background-color: #ffffff;">Order Receive Date = mm/dd/yyyy</SPAN>) from Source Excel file, where cell no is keep changing and the paste that cell value to another excel.</STRONG></SPAN><BR /><BR /><SPAN style="color: #000080;"><STRONG>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.</STRONG></SPAN><BR /><BR /><SPAN style="color: #000080;"><STRONG>For Sales Order = 123456-100 Order Received Date = 01/01/2020 Cell NO = B2 - Source Excel File</STRONG></SPAN><BR /><SPAN style="color: #000080;"><STRONG>For Sales Order = 123456-200 <SPAN style="text-align: left; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Nunito Sans',sans-serif; font-size: 14px; font-style: normal; font-variant: normal; text-decoration: none; word-spacing: 0px; display: inline !important; white-space: normal; cursor: text; orphans: 2; float: none; -webkit-text-stroke-width: 0px; background-color: #ffffff;">Order Received Date = 01/01/2020 Cell NO = B3 - Source Excel File</SPAN></STRONG></SPAN><BR /><BR />------------------------------<BR />Asitabha Deb<BR />------------------------------<BR /> Wed, 25 Nov 2020 08:02:00 GMT https://community.blueprism.com/t5/Product-Forum/Copy-CellValue-from-changing-Cell-no-and-paste-paste-it-to/m-p/59535#M13161 AsitabhaDeb 2020-11-25T08:02:00Z https://community.blueprism.com/t5/Product-Forum/Copy-CellValue-from-changing-Cell-no-and-paste-paste-it-to/m-p/59536#M13162 Hi <A id="MainCopy_ctl10_ucMessageList_rptMessageList_ProfileImageDisplay_0_NameLink_0" biobubblekey="f18e4bb4-b698-44a7-bcf3-41fd9b0a8ebe" href="https://community.blueprism.com/network/profile?UserKey=f18e4bb4-b698-44a7-bcf3-41fd9b0a8ebe" target="_blank" rel="noopener">Asitabha</A><BR /><BR />You can get both excel data into the collection.and match as per your the data as per requirement<BR /><BR />use write collection action to print final data into excel.<BR /><BR />Thanks<BR /><BR /><BR />------------------------------<BR />Nilesh Jadhav <BR />Senior RPA Specialist<BR />ADP<BR />India<BR />------------------------------<BR /> Thu, 26 Nov 2020 19:53:00 GMT https://community.blueprism.com/t5/Product-Forum/Copy-CellValue-from-changing-Cell-no-and-paste-paste-it-to/m-p/59536#M13162 NileshJadhavBP 2020-11-26T19:53:00Z