Grab and list URLs of multiple sheets/tab
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Not sure if this can be done by plugging in a formula in a cell and dragging down, or if it needs a script.
I'm initially inclined to just use a formula since I can use INDIRECT to reference to my sheets, but I don't know if a function exists that can grab a URL from the referenced sheet or if I need to write a script to do so.
Any help pointing me to a direction or even an actual solution would be most invaluable since I'm dealing with 200+ sheets here, and going to each sheet, to grab the url and then going back to my master sheet to paste them is very cumbersome and can become confusing.
EDIT:
=INDIRECT("Sheet"&ROW()&"!A1")
since it isn't clear for others here where my roadblock is, this is where I'm at. I have no idea how or if it is at all possible through a formula to grab a URL, or if I need a script.
google-sheets
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
add a comment |
Not sure if this can be done by plugging in a formula in a cell and dragging down, or if it needs a script.
I'm initially inclined to just use a formula since I can use INDIRECT to reference to my sheets, but I don't know if a function exists that can grab a URL from the referenced sheet or if I need to write a script to do so.
Any help pointing me to a direction or even an actual solution would be most invaluable since I'm dealing with 200+ sheets here, and going to each sheet, to grab the url and then going back to my master sheet to paste them is very cumbersome and can become confusing.
EDIT:
=INDIRECT("Sheet"&ROW()&"!A1")
since it isn't clear for others here where my roadblock is, this is where I'm at. I have no idea how or if it is at all possible through a formula to grab a URL, or if I need a script.
google-sheets
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
The question doesn't appear to include any attempt at all to solve the problem. StackOverflow expects you to try to solve your own problem first, as your attempts help us to better understand what you want. Please edit the question to show what you've tried, and show a specific roadblock you're running into with Minimal, Complete, and Verifiable example. For more information, please see How to Ask.
– Andreas
Nov 29 '18 at 2:17
I've already mentioned that I can reference to my sheets usingINDIRECTand explained my specific roadblock. nonetheless, I edited my post to show where I'm at
– Mandirigma
Nov 29 '18 at 2:28
I don't see the problem. Your formula works, and it is dynamic, so just start in row 1 and copy it down 200+ rows. BUT, when you say "200+ sheets", do you mean one spreadsheet with 200 sheets, or 200 spreadsheets? If you are referring to 200 spreadsheets, then 1) a script is the best approach (and is easy to do), and 2) are all the spreadsheets in the same folder/sub-folders and do you have access to them all? You've specifically referred to a URL that exists in cell A1 of sheet1 of each "sheet" - is this a run-of-the-mill URL, or the URL required to open a specific spreadsheet/sheet?
– Tedinoz
Dec 10 '18 at 14:30
add a comment |
Not sure if this can be done by plugging in a formula in a cell and dragging down, or if it needs a script.
I'm initially inclined to just use a formula since I can use INDIRECT to reference to my sheets, but I don't know if a function exists that can grab a URL from the referenced sheet or if I need to write a script to do so.
Any help pointing me to a direction or even an actual solution would be most invaluable since I'm dealing with 200+ sheets here, and going to each sheet, to grab the url and then going back to my master sheet to paste them is very cumbersome and can become confusing.
EDIT:
=INDIRECT("Sheet"&ROW()&"!A1")
since it isn't clear for others here where my roadblock is, this is where I'm at. I have no idea how or if it is at all possible through a formula to grab a URL, or if I need a script.
google-sheets
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
Not sure if this can be done by plugging in a formula in a cell and dragging down, or if it needs a script.
I'm initially inclined to just use a formula since I can use INDIRECT to reference to my sheets, but I don't know if a function exists that can grab a URL from the referenced sheet or if I need to write a script to do so.
Any help pointing me to a direction or even an actual solution would be most invaluable since I'm dealing with 200+ sheets here, and going to each sheet, to grab the url and then going back to my master sheet to paste them is very cumbersome and can become confusing.
EDIT:
=INDIRECT("Sheet"&ROW()&"!A1")
since it isn't clear for others here where my roadblock is, this is where I'm at. I have no idea how or if it is at all possible through a formula to grab a URL, or if I need a script.
google-sheets
google-sheets
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
edited Nov 29 '18 at 2:27
Mandirigma
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
asked Nov 29 '18 at 2:15
MandirigmaMandirigma
147
147
The question doesn't appear to include any attempt at all to solve the problem. StackOverflow expects you to try to solve your own problem first, as your attempts help us to better understand what you want. Please edit the question to show what you've tried, and show a specific roadblock you're running into with Minimal, Complete, and Verifiable example. For more information, please see How to Ask.
– Andreas
Nov 29 '18 at 2:17
I've already mentioned that I can reference to my sheets usingINDIRECTand explained my specific roadblock. nonetheless, I edited my post to show where I'm at
– Mandirigma
Nov 29 '18 at 2:28
I don't see the problem. Your formula works, and it is dynamic, so just start in row 1 and copy it down 200+ rows. BUT, when you say "200+ sheets", do you mean one spreadsheet with 200 sheets, or 200 spreadsheets? If you are referring to 200 spreadsheets, then 1) a script is the best approach (and is easy to do), and 2) are all the spreadsheets in the same folder/sub-folders and do you have access to them all? You've specifically referred to a URL that exists in cell A1 of sheet1 of each "sheet" - is this a run-of-the-mill URL, or the URL required to open a specific spreadsheet/sheet?
– Tedinoz
Dec 10 '18 at 14:30
add a comment |
The question doesn't appear to include any attempt at all to solve the problem. StackOverflow expects you to try to solve your own problem first, as your attempts help us to better understand what you want. Please edit the question to show what you've tried, and show a specific roadblock you're running into with Minimal, Complete, and Verifiable example. For more information, please see How to Ask.
– Andreas
Nov 29 '18 at 2:17
I've already mentioned that I can reference to my sheets usingINDIRECTand explained my specific roadblock. nonetheless, I edited my post to show where I'm at
– Mandirigma
Nov 29 '18 at 2:28
I don't see the problem. Your formula works, and it is dynamic, so just start in row 1 and copy it down 200+ rows. BUT, when you say "200+ sheets", do you mean one spreadsheet with 200 sheets, or 200 spreadsheets? If you are referring to 200 spreadsheets, then 1) a script is the best approach (and is easy to do), and 2) are all the spreadsheets in the same folder/sub-folders and do you have access to them all? You've specifically referred to a URL that exists in cell A1 of sheet1 of each "sheet" - is this a run-of-the-mill URL, or the URL required to open a specific spreadsheet/sheet?
– Tedinoz
Dec 10 '18 at 14:30
The question doesn't appear to include any attempt at all to solve the problem. StackOverflow expects you to try to solve your own problem first, as your attempts help us to better understand what you want. Please edit the question to show what you've tried, and show a specific roadblock you're running into with Minimal, Complete, and Verifiable example. For more information, please see How to Ask.
– Andreas
Nov 29 '18 at 2:17
The question doesn't appear to include any attempt at all to solve the problem. StackOverflow expects you to try to solve your own problem first, as your attempts help us to better understand what you want. Please edit the question to show what you've tried, and show a specific roadblock you're running into with Minimal, Complete, and Verifiable example. For more information, please see How to Ask.
– Andreas
Nov 29 '18 at 2:17
I've already mentioned that I can reference to my sheets using
INDIRECT and explained my specific roadblock. nonetheless, I edited my post to show where I'm at– Mandirigma
Nov 29 '18 at 2:28
I've already mentioned that I can reference to my sheets using
INDIRECT and explained my specific roadblock. nonetheless, I edited my post to show where I'm at– Mandirigma
Nov 29 '18 at 2:28
I don't see the problem. Your formula works, and it is dynamic, so just start in row 1 and copy it down 200+ rows. BUT, when you say "200+ sheets", do you mean one spreadsheet with 200 sheets, or 200 spreadsheets? If you are referring to 200 spreadsheets, then 1) a script is the best approach (and is easy to do), and 2) are all the spreadsheets in the same folder/sub-folders and do you have access to them all? You've specifically referred to a URL that exists in cell A1 of sheet1 of each "sheet" - is this a run-of-the-mill URL, or the URL required to open a specific spreadsheet/sheet?
– Tedinoz
Dec 10 '18 at 14:30
I don't see the problem. Your formula works, and it is dynamic, so just start in row 1 and copy it down 200+ rows. BUT, when you say "200+ sheets", do you mean one spreadsheet with 200 sheets, or 200 spreadsheets? If you are referring to 200 spreadsheets, then 1) a script is the best approach (and is easy to do), and 2) are all the spreadsheets in the same folder/sub-folders and do you have access to them all? You've specifically referred to a URL that exists in cell A1 of sheet1 of each "sheet" - is this a run-of-the-mill URL, or the URL required to open a specific spreadsheet/sheet?
– Tedinoz
Dec 10 '18 at 14:30
add a comment |
0
active
oldest
votes
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/3.0/"u003ecc by-sa 3.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%2f53530887%2fgrab-and-list-urls-of-multiple-sheets-tab%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53530887%2fgrab-and-list-urls-of-multiple-sheets-tab%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
The question doesn't appear to include any attempt at all to solve the problem. StackOverflow expects you to try to solve your own problem first, as your attempts help us to better understand what you want. Please edit the question to show what you've tried, and show a specific roadblock you're running into with Minimal, Complete, and Verifiable example. For more information, please see How to Ask.
– Andreas
Nov 29 '18 at 2:17
I've already mentioned that I can reference to my sheets using
INDIRECTand explained my specific roadblock. nonetheless, I edited my post to show where I'm at– Mandirigma
Nov 29 '18 at 2:28
I don't see the problem. Your formula works, and it is dynamic, so just start in row 1 and copy it down 200+ rows. BUT, when you say "200+ sheets", do you mean one spreadsheet with 200 sheets, or 200 spreadsheets? If you are referring to 200 spreadsheets, then 1) a script is the best approach (and is easy to do), and 2) are all the spreadsheets in the same folder/sub-folders and do you have access to them all? You've specifically referred to a URL that exists in cell A1 of sheet1 of each "sheet" - is this a run-of-the-mill URL, or the URL required to open a specific spreadsheet/sheet?
– Tedinoz
Dec 10 '18 at 14:30