How to auto update using from one sheet to another using Vlookup without overwriting the cells values

ITShiva

New Member
Joined
Nov 26, 2015
Messages
2
Hi To Everyone,

I am trying to achieve the following Task.. Assume I have 2 different google spreadsheets. Spreadsheet A having 300 entries & it will update daily basis, having Range of A1:O300.

In SpreadSheet B, I have two <gs id="55e0d86b-3755-427b-b8db-ebeda470bba6" ginger_software_uiphraseguid="1bc4f3ab-fe43-49ff-a973-9e5bde064281" class="GINGER_SOFTWARE_mark">sheets</gs>. In sheet 2, using =ImportRange () imported all the data from SpreadSheet A to Spreadsheet B. Now in the sheet 1, using VLookup formula I am just pulling 10 rows of the data

The problem is, if the Spreadsheet A updates next day, it will update my values in the Spreadsheet B under the Sheet 1.

Is there any way to write, the newest result <gs id="95f6fd6d-3f17-4961-b64f-a4c4cbe0233c" ginger_software_uiphraseguid="e72d68ac-6f0c-43b1-9b12-2baee367b962" class="GINGER_SOFTWARE_mark">to be</gs> on the top & not overwriting the <gs id="dfeebe20-8843-4165-b3d3-366249cecadd" ginger_software_uiphraseguid="e72d68ac-6f0c-43b1-9b12-2baee367b962" class="GINGER_SOFTWARE_mark">data</gs>? Also, I need to apply the VLookup to filter just 10 selected rows for each day..

Has there been a way to do this automatically? Looking for the help
 

portews

Active Member
Joined
Sep 4, 2009
Messages
303
Just to be sure, do you want to insert the entire range from A to B every day, inserting it at the top? And you want Sheet1 to have ten lookup rows for each day on B sheet 1? Do you want to delete any day ranges on B sheet 2 and if so when? If not, with an xls file, you'll only get 218 days per spreadsheet B, sheet 2. Is the criteria for the lookup the same for each day?

Unless you need to keep the raw data on sheet 2, you could do your lookup from Book A to Book B Sheet 1 and return only the 10 rows you're looking for. Would this do?

If you want more detailed help, you may have to post a sample database to get specifics about what you're looking for.
 

ITShiva

New Member
Joined
Nov 26, 2015
Messages
2
Happy thanksgiving day <gs id="c0f98274-e860-4511-8219-f5adc2526d88" ginger_software_uiphraseguid="3be64f7b-c283-4664-b15d-a24c3c9af0ae" class="GINGER_SOFTWARE_mark">portews</gs>,

Thanks for your response. I have attached my screenshot below, which explains my requirements. Please check it & let me know, if you need any other details.


 

Forum statistics

Threads
1,085,335
Messages
5,383,032
Members
401,812
Latest member
topherj09

Some videos you may like

This Week's Hot Topics

Top