https://community.blueprism.com/t5/Product-Forum/When-I-am-trying-to-copy-a-full-sheet-to-another-sheet-by-using/m-p/71514#M24119 Thank you Robin for your help.<BR />Yes this is excel.<BR /><BR />We are working on a project automation where our Federal client just bought the Blue Prism license&nbsp; and they have a large volume of data to be dealt.<BR />and the data will keep growing.<BR /><BR />Could you please help guide me how to use the following approach via Blue Prism : <SPAN>Use keyboard shortcuts (e.g. "Select All", "Copy", "Paste") .<BR /><BR />Appreciate your help and thank you very much!!</SPAN><BR /><BR />------------------------------<BR />RPA Job Opportunity<BR />------------------------------<BR /> Wed, 27 Jan 2021 23:04:00 GMT RPAJob_Opportun 2021-01-27T23:04:00Z https://community.blueprism.com/t5/Product-Forum/When-I-am-trying-to-copy-a-full-sheet-to-another-sheet-by-using/m-p/71512#M24117 When I am trying to copy a full sheet to another sheet by using get collection and write collection functionality, it takes a long long time since my excel sheet has a lot of data.<BR /><BR />Is there any other way to efficiently copy the sheet to another sheet.<BR /><BR />------------------------------<BR />RPA Job Opportunity<BR />------------------------------<BR /> Wed, 27 Jan 2021 12:52:00 GMT https://community.blueprism.com/t5/Product-Forum/When-I-am-trying-to-copy-a-full-sheet-to-another-sheet-by-using/m-p/71512#M24117 RPAJob_Opportun 2021-01-27T12:52:00Z https://community.blueprism.com/t5/Product-Forum/When-I-am-trying-to-copy-a-full-sheet-to-another-sheet-by-using/m-p/71513#M24118 I'm assuming based on the phrasing ("Sheet to sheet") that you mean Excel, and based on that two alternate possibilities immediately come to mind:<BR /><BR /> <OL> <LI>Use keyboard shortcuts (e.g. "Select All", "Copy", "Paste") instead of using the VBO functions. The VBO, for "get collection" and "write collection", is introducing overhead - construct the collection, fill it, etc. Using keyboard shortcuts relies only on the client and the OS, reducing overhead and possibly speeding it up.</LI> <LI>OleDB can - depending on circumstance - offer significant efficiencies for raw data reads/writes.</LI> </OL> That being said, I'd love to hear other suggestions from the community.<BR /><BR />If you don't mean Excel, could you please clarify?<BR />Thanks!<BR /><BR />------------------------------<BR />Robin Toll<BR />Senior Technical Consultant<BR />Blue Prism<BR />Professional Services Americas<BR />Infrastructure &amp; Architecture Specialist<BR />------------------------------<BR /> Wed, 27 Jan 2021 14:49:00 GMT https://community.blueprism.com/t5/Product-Forum/When-I-am-trying-to-copy-a-full-sheet-to-another-sheet-by-using/m-p/71513#M24118 RobinToll 2021-01-27T14:49:00Z https://community.blueprism.com/t5/Product-Forum/When-I-am-trying-to-copy-a-full-sheet-to-another-sheet-by-using/m-p/71514#M24119 Thank you Robin for your help.<BR />Yes this is excel.<BR /><BR />We are working on a project automation where our Federal client just bought the Blue Prism license&nbsp; and they have a large volume of data to be dealt.<BR />and the data will keep growing.<BR /><BR />Could you please help guide me how to use the following approach via Blue Prism : <SPAN>Use keyboard shortcuts (e.g. "Select All", "Copy", "Paste") .<BR /><BR />Appreciate your help and thank you very much!!</SPAN><BR /><BR />------------------------------<BR />RPA Job Opportunity<BR />------------------------------<BR /> Wed, 27 Jan 2021 23:04:00 GMT https://community.blueprism.com/t5/Product-Forum/When-I-am-trying-to-copy-a-full-sheet-to-another-sheet-by-using/m-p/71514#M24119 RPAJob_Opportun 2021-01-27T23:04:00Z