https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49511#M4898 hello everyone, just asking if what action can be done when retrieving another spreadsheet and incorporate it in another excel sheet sample sheet1(main file) sheet2(is another file came from other excel source) in sheet1 there are column needed to be filled up using function vlookup(A3,sheet2!B:G,6,0) and (A3,sheet2!B:H,7,0)   thanks in advance Wed, 21 Nov 2018 21:22:00 GMT ChristopherSuba 2018-11-21T21:22:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49511#M4898 hello everyone, just asking if what action can be done when retrieving another spreadsheet and incorporate it in another excel sheet sample sheet1(main file) sheet2(is another file came from other excel source) in sheet1 there are column needed to be filled up using function vlookup(A3,sheet2!B:G,6,0) and (A3,sheet2!B:H,7,0)   thanks in advance Wed, 21 Nov 2018 21:22:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49511#M4898 ChristopherSuba 2018-11-21T21:22:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49512#M4899 Use the ""Copy and Paste Worksheet Range"" action. If you don't have it, I'm attaching it as XML in a text file. Copy it to clipboard and paste as a new page in your VBO. Wed, 21 Nov 2018 21:47:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49512#M4899 AmiBarrett 2018-11-21T21:47:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49513#M4900 (And it didn't attach. Trying again.) Wed, 21 Nov 2018 21:47:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49513#M4900 AmiBarrett 2018-11-21T21:47:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49514#M4901 Trying to attach as XML. I think some part of the system is blocking the contents. Wed, 21 Nov 2018 21:50:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49514#M4901 AmiBarrett 2018-11-21T21:50:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49515#M4902 thank you for the feedback Wed, 21 Nov 2018 21:51:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49515#M4902 ChristopherSuba 2018-11-21T21:51:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49516#M4903 and secondly how to manipulate those vlookup function? Wed, 21 Nov 2018 21:52:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49516#M4903 ChristopherSuba 2018-11-21T21:52:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49517#M4904 This is an icky alternative, but it seems to be the only way this forum software is happy with me sharing the action. Attached is a screenshot of the code stage. Ins and Outs are below. In: Handle - Number Source Workbook - Text Source Worksheet - Text Source Range - Text Destination Workbook - Text Destination Worksheet - Text Destination Range - Text Out: Success - Flag Message - Text Wed, 21 Nov 2018 21:54:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49517#M4904 AmiBarrett 2018-11-21T21:54:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49518#M4905 You could probably use another action to add a formula to a cell or cell range. cells.Select() source = excel.Selection source.Formula=Formula source.Columns.AutoFit Wed, 21 Nov 2018 21:57:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49518#M4905 AmiBarrett 2018-11-21T21:57:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49519#M4906 just to add on the scenario that I inquiry i have already a collection and there are blank column, those 2 column have function vlookup and the data needed is with another sheet(sheet2)"" vlookup(A3,sheet2!B:G,6,0) and (A3,sheet2!B:H,7,0) "" how to be able to append or populate those blank column with the input coming from the vlookup, Thu, 22 Nov 2018 15:33:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49519#M4906 ChristopherSuba 2018-11-22T15:33:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49520#M4907 Again, you should be able to set a formula for those cells using that last code excerpt. Insert your vlookup and it should populate. Afterward, you should be able to read it to a collection without issue. Mon, 26 Nov 2018 20:32:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49520#M4907 AmiBarrett 2018-11-26T20:32:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49521#M4908 hello again, how to convert into sql string using oledb for this filterin Filter date column, choose blank and all the months that are included in the current tax year (Mar 1 - Current) thanks Fri, 30 Nov 2018 14:53:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49521#M4908 ChristopherSuba 2018-11-30T14:53:00Z https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49522#M4909 hello team, just want to ask for help to get next row record after validation. Tue, 18 Dec 2018 22:06:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-collect-another-sheet-data-with-in-the-single-file/m-p/49522#M4909 ChristopherSuba 2018-12-18T22:06:00Z