Procedurally Referencing Data Across Multiple Sheet in Google SheetsUsing A Cell To Reference The Name Of Sheet In A Formula For Google SheetsString excerptsAdapting Google Sheets API Node.js Quickstart to work with my own sheet, error: Error: Unable to parse range: Class Data!A2:EG-Sheets: Populate multiple cells from another sheet based on dropdown (multiple rows and columns)Google Sheet Back End Data IntegrityGoogle Sheets: Vlookup and IF conditionGoogle Sheets, Forms and Query for updating data to multiple sheets?Google Sheets: Overwrite Error using ARRAYFORMULA + VLOOKUPCombining multiple Google sheets into single Google spreadsheet
Fermat's Last Theorem, mod n
Fake TL072/TL074 IC's - how does the economics of it work?
What spells can be countered?
What are these criss-cross patterns close to Cambridge Airport (UK)?
I'm being blamed for not responding to an email from a client that was directly addressed to coworker
Which skill would I use for ventriloquism?
What type of beer is best for beer battered fish?
How do the Martian rebels defeat Earth when they're grossly outnumbered and outgunned?
How to use FDE without needing to share the encryption password
Why did the Bohr Model Successfully calculate some of the energy levels in hydrogen?
How to avoid answering "what were you sick with"?
Does SQL Server Only Perform Calculations In A SELECT List Once?
Why does Smaug have 4 legs in the 1st movie but only 2 legs in the 2nd?
How much money is needed to prove you can support yourself with ESTA
Bash to check if directory exist. If not create with an array
How much money would I need to feel secure in my job?
Possible executive assistant job scam
Can I request a credit item be removed from my report as soon as it is paid in full?
A variation on Caesar
"Cобака на сене" - is this expression still in use or is it dated?
Can I scale all line widths in a tikzpicture?
Dicht antonym - what is it?
Implement the Max-Pooling operation from Convolutional Neural Networks
When should we use "Got it?" and "Get it?"
Procedurally Referencing Data Across Multiple Sheet in Google Sheets
Using A Cell To Reference The Name Of Sheet In A Formula For Google SheetsString excerptsAdapting Google Sheets API Node.js Quickstart to work with my own sheet, error: Error: Unable to parse range: Class Data!A2:EG-Sheets: Populate multiple cells from another sheet based on dropdown (multiple rows and columns)Google Sheet Back End Data IntegrityGoogle Sheets: Vlookup and IF conditionGoogle Sheets, Forms and Query for updating data to multiple sheets?Google Sheets: Overwrite Error using ARRAYFORMULA + VLOOKUPCombining multiple Google sheets into single Google spreadsheet
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;
I'm trying to dynamically reference data from multiple sheets into multiple cells on one sheet. I'm constantly creating new sheets within the same workbook. I'd like to be able to set it up to where I can easily auto-populate the cells with the data from a new sheet instead of having to rewrite the formula with the new sheet's name.
I'm currently using ='sheetname'!B1 to reference the data from multiple sheets. The problem is when I click and drag the cell to reference a different sheet it changes to ='sheetname'!B2. I've set up the A column with the names of the sheets and tried to figure out a way to reference those as the sheet names but was unsuccessful. Here is a link to a google sheet that shows the problem I'm having:
https://docs.google.com/spreadsheets/d/1lVPemberRSKDcHc3ogz4XE_PTgSAO9IYXx5RCmVQ9C8/edit?usp=sharing
I want the cell B2 in "Totals" to reference A2 as the sheet name and then I want to be able to click and drag so that B3 references A3 as the cell name but doesn't change the cell that it is pulling data from on each of the different sheets.
google-sheets
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
add a comment
|
I'm trying to dynamically reference data from multiple sheets into multiple cells on one sheet. I'm constantly creating new sheets within the same workbook. I'd like to be able to set it up to where I can easily auto-populate the cells with the data from a new sheet instead of having to rewrite the formula with the new sheet's name.
I'm currently using ='sheetname'!B1 to reference the data from multiple sheets. The problem is when I click and drag the cell to reference a different sheet it changes to ='sheetname'!B2. I've set up the A column with the names of the sheets and tried to figure out a way to reference those as the sheet names but was unsuccessful. Here is a link to a google sheet that shows the problem I'm having:
https://docs.google.com/spreadsheets/d/1lVPemberRSKDcHc3ogz4XE_PTgSAO9IYXx5RCmVQ9C8/edit?usp=sharing
I want the cell B2 in "Totals" to reference A2 as the sheet name and then I want to be able to click and drag so that B3 references A3 as the cell name but doesn't change the cell that it is pulling data from on each of the different sheets.
google-sheets
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
add a comment
|
I'm trying to dynamically reference data from multiple sheets into multiple cells on one sheet. I'm constantly creating new sheets within the same workbook. I'd like to be able to set it up to where I can easily auto-populate the cells with the data from a new sheet instead of having to rewrite the formula with the new sheet's name.
I'm currently using ='sheetname'!B1 to reference the data from multiple sheets. The problem is when I click and drag the cell to reference a different sheet it changes to ='sheetname'!B2. I've set up the A column with the names of the sheets and tried to figure out a way to reference those as the sheet names but was unsuccessful. Here is a link to a google sheet that shows the problem I'm having:
https://docs.google.com/spreadsheets/d/1lVPemberRSKDcHc3ogz4XE_PTgSAO9IYXx5RCmVQ9C8/edit?usp=sharing
I want the cell B2 in "Totals" to reference A2 as the sheet name and then I want to be able to click and drag so that B3 references A3 as the cell name but doesn't change the cell that it is pulling data from on each of the different sheets.
google-sheets
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
I'm trying to dynamically reference data from multiple sheets into multiple cells on one sheet. I'm constantly creating new sheets within the same workbook. I'd like to be able to set it up to where I can easily auto-populate the cells with the data from a new sheet instead of having to rewrite the formula with the new sheet's name.
I'm currently using ='sheetname'!B1 to reference the data from multiple sheets. The problem is when I click and drag the cell to reference a different sheet it changes to ='sheetname'!B2. I've set up the A column with the names of the sheets and tried to figure out a way to reference those as the sheet names but was unsuccessful. Here is a link to a google sheet that shows the problem I'm having:
https://docs.google.com/spreadsheets/d/1lVPemberRSKDcHc3ogz4XE_PTgSAO9IYXx5RCmVQ9C8/edit?usp=sharing
I want the cell B2 in "Totals" to reference A2 as the sheet name and then I want to be able to click and drag so that B3 references A3 as the cell name but doesn't change the cell that it is pulling data from on each of the different sheets.
google-sheets
google-sheets
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
edited Mar 29 at 2:42
player0
27.3k6 gold badges20 silver badges44 bronze badges
27.3k6 gold badges20 silver badges44 bronze badges
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
asked Mar 28 at 21:20
Adam Michael OgdenAdam Michael Ogden
1
1
add a comment
|
add a comment
|
1 Answer
1
active
oldest
votes
I actually figured it out. You have to use =INDIRECT("'"&A2&"'!B12"). Way more simple than I thought it was going to be...
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
add a comment
|
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55407012%2fprocedurally-referencing-data-across-multiple-sheet-in-google-sheets%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I actually figured it out. You have to use =INDIRECT("'"&A2&"'!B12"). Way more simple than I thought it was going to be...
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
add a comment
|
I actually figured it out. You have to use =INDIRECT("'"&A2&"'!B12"). Way more simple than I thought it was going to be...
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
add a comment
|
I actually figured it out. You have to use =INDIRECT("'"&A2&"'!B12"). Way more simple than I thought it was going to be...
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
I actually figured it out. You have to use =INDIRECT("'"&A2&"'!B12"). Way more simple than I thought it was going to be...
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
answered Mar 28 at 22:45
Adam Michael OgdenAdam Michael Ogden
1
1
add a comment
|
add a comment
|
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55407012%2fprocedurally-referencing-data-across-multiple-sheet-in-google-sheets%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
