Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

Google Sheets Question

So I have a Google sheets layout and I need the information from a certain column in each of 5 separate tabs to auto populate onto a "master" tab. I believe this is done under data validation, though thing is; what I need is for the master sheet to update automatically when I update the information on sheets 1-5. Any assistance with this would be grateful.

 

My brain is a muddy mess today so be gentle ...Google Docs/Sheets is not my common use for this kind of thing and it has been a long while since I have done this with MS Excel.

 

Thank you in advance.

COMMUNITY STANDARDS   |   TECH NEWS POSTING GUIDELINES   |   FORUM STAFF

LTT Folding Users Tips, Tricks and FAQ   |   F@H & BOINC Badge Request   |   F@H Contribution    My Rig   |   Project Steamroller

 

Spoiler

  

 

 

Character is like a Tree and Reputation like its Shadow. The Shadow is what we think of it; The Tree is the Real thing.  ~ Abraham Lincoln

Reputation is a Lifetime to create but seconds to destroy.

You have enemies? Good. That means you've stood up for something, sometime in your life.  ~ Winston Churchill

Docendo discimus - "to teach is to learn"

 

I am a StarCitizen are you? My ships: Aegis Eclipse, Aegis Sabre, Aegis Gladius, Aopoa Nox, KI P52 Merlin, KI P72 Archimedes and the RSI Constellation Aquila.

 

My phones are a Samsung Note 20 and a Samsung S9+

 

🇺🇸   About Myself:   https://linustechtips.com/main/profile/229093-sansvarnic/?tab=field_core_pfield_46   🇺🇸

 

 CHRISTIAN MEMBER 

 

 
 
 
 
 
 

 

Link to comment
Share on other sites

Link to post
Share on other sites

Simple solution that might work is using

='Sheet1'!A1

 or whatever the top cell (A1) of the data column and sheet name (Sheet1), and just dragging it down. Rinse and repeat for each data set. This might be a pain for larger data sets.

Link to comment
Share on other sites

Link to post
Share on other sites

7 hours ago, Dissitesuxba11s said:

Simple solution that might work is using


='Sheet1'!A1

 or whatever the top cell (A1) of the data column and sheet name (Sheet1), and just dragging it down. Rinse and repeat for each data set. This might be a pain for larger data sets.

It works to get the drop down list but I need is for the information populate on its own like in excel with relationships that can be created.

it been years since I did this last and its even changed with excel... I need to relearn how to do this.

COMMUNITY STANDARDS   |   TECH NEWS POSTING GUIDELINES   |   FORUM STAFF

LTT Folding Users Tips, Tricks and FAQ   |   F@H & BOINC Badge Request   |   F@H Contribution    My Rig   |   Project Steamroller

 

Spoiler

  

 

 

Character is like a Tree and Reputation like its Shadow. The Shadow is what we think of it; The Tree is the Real thing.  ~ Abraham Lincoln

Reputation is a Lifetime to create but seconds to destroy.

You have enemies? Good. That means you've stood up for something, sometime in your life.  ~ Winston Churchill

Docendo discimus - "to teach is to learn"

 

I am a StarCitizen are you? My ships: Aegis Eclipse, Aegis Sabre, Aegis Gladius, Aopoa Nox, KI P52 Merlin, KI P72 Archimedes and the RSI Constellation Aquila.

 

My phones are a Samsung Note 20 and a Samsung S9+

 

🇺🇸   About Myself:   https://linustechtips.com/main/profile/229093-sansvarnic/?tab=field_core_pfield_46   🇺🇸

 

 CHRISTIAN MEMBER 

 

 
 
 
 
 
 

 

Link to comment
Share on other sites

Link to post
Share on other sites

12 minutes ago, SansVarnic said:

It works to get the drop down list but I need is for the information populate on its own like in excel with relationships that can be created.

it been years since I did this last and its even changed with excel... I need to relearn how to do this.

I might have been confused by your initial query. So you want the master sheet have all drop down menus?

 

Example:
Sheet 2 has a column of odd numbers, while sheet 3 has a column of even numbers. You want the master sheer, sheet 1, to have two column, one with just the odd numbers and the other just even numbers, but you want these to be from a drop down menu? Correct me if I'm wrong.

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×