tempobet tipobet Instagram Profiles
Any Google sheets boffins out there? - Peoples Republic Of Cork Discussion Forums

Go Back   Peoples Republic Of Cork Discussion Forums > Tech Forum
User Name
Password
Reply
 
Thread Tools Display Modes
  #1  
Old 15-08-2019, 07:01 AM
Beaty Beaty is offline
 
Join Date: Oct 2006
Location: In Utero
Posts: 13,254
Default Any Google sheets boffins out there?

Google Sheets Query:

I have a Google Document with ten sheets (numbered Sheet 01 to Sheet 10)

I have an line of text (several columns wide) in each sheet I want to group in a new Sheet 11, lets call the line of text a SALE.

How can I write some code, in Sheet 11 that, will pick up each 'SALE' and from Sheet 01 - 10 and list them in that sheet?

B
__________________
To be married, is to be divorced from one's self.
Reply With Quote
  #2  
Old 16-08-2019, 11:16 PM
Account Attempt No.4 Account Attempt No.4 is offline
PROC Member
 
Join Date: Dec 2018
Posts: 95
Default

Quote:
Originally Posted by Beaty View Post
Google Sheets Query:

I have a Google Document with ten sheets (numbered Sheet 01 to Sheet 10)

I have an line of text (several columns wide) in each sheet I want to group in a new Sheet 11, lets call the line of text a SALE.

How can I write some code, in Sheet 11 that, will pick up each 'SALE' and from Sheet 01 - 10 and list them in that sheet?

B
Can you create a dummy one with what you need and link it? Be easier that way.
Reply With Quote
  #3  
Old 23-08-2019, 04:58 AM
Beaty Beaty is offline
 
Join Date: Oct 2006
Location: In Utero
Posts: 13,254
Default

Quote:
Originally Posted by Account Attempt No.4 View Post
Can you create a dummy one with what you need and link it? Be easier that way.
Sorry, not following, a dummy on for you to see?

B
__________________
To be married, is to be divorced from one's self.
Reply With Quote
  #4  
Old 26-08-2019, 12:15 AM
Beaty Beaty is offline
 
Join Date: Oct 2006
Location: In Utero
Posts: 13,254
Default

Found it!---->

What if you want to make two entirely separate files talk to each other, referencing data back and forth between them?

To link Google Sheets, we'll need to learn about the IMPORTRANGE function. This is the best way to pull in data from separate files in Sheets and use that data inside the active sheet.

It helps to have both spreadsheets open while you're working with IMPORTRANGE so that you can easily check what cells need to be brought into your spreadsheet.

To get started with this function, let's type in =IMPORTRANGE. Next, grab the URL for the Sheet that you want to pull data from, and paste it in quotation marks in the first part of the function.

Next, you'll need to add the name of the sheet followed by an exclamation point. Then, specify the cells that you want to pull the data from.

B
__________________
To be married, is to be divorced from one's self.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump










All times are GMT. The time now is 04:26 PM.


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
All forum comments are the sole responsibility and property of forum users. PeoplesRepublicOfCork.com and its sponsors disclaim all liability for content posted by users of the forum. PeoplesRepublicOfCork.com and its sponsors do not necessarily share the views expressed in this forum. Use the report post system to have comments considered for edit or deletion. All users are IP logged. Website hosted by Hostrocket USA.