Tab reference links
up vote
0
down vote
favorite
I have a workbook in excel with monthly tabs and links form tab to tab. i.e. beginning balance in February pull from ending balance in January. When I copy a tab, say March to Create April, the new Tab will still link back to the February tab instead of the previous tab which would be March. So I go in to April and change all the links to March form February. Is there a way to set up the link so when I create a new tab using the copy function that the links will just refer to the the appropriate tab?
microsoft-excel
asked Nov 16 at 16:54
Chuck
1
add a comment |
up vote
0
down vote
favorite
I have a workbook in excel with monthly tabs and links form tab to tab. i.e. beginning balance in February pull from ending balance in January. When I copy a tab, say March to Create April, the new Tab will still link back to the February tab instead of the previous tab which would be March. So I go in to April and change all the links to March form February. Is there a way to set up the link so when I create a new tab using the copy function that the links will just refer to the the appropriate tab?
microsoft-excel
asked Nov 16 at 16:54
Chuck
1
1
Use one cell for storing the source worksheet name. Make all your references relative to it.
– Akina
Nov 16 at 17:28
@Akina it's a good candidate answer.. you should put it as full answer for this one.. you may throw an example to illustrate it. ( :
– p._phidot_
Nov 16 at 18:23
I'm lazy... sorry. And the solution seems is not difficult, the author can do it self I think...
– Akina
Nov 16 at 18:49
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a workbook in excel with monthly tabs and links form tab to tab. i.e. beginning balance in February pull from ending balance in January. When I copy a tab, say March to Create April, the new Tab will still link back to the February tab instead of the previous tab which would be March. So I go in to April and change all the links to March form February. Is there a way to set up the link so when I create a new tab using the copy function that the links will just refer to the the appropriate tab?
microsoft-excel
asked Nov 16 at 16:54
Chuck
1
I have a workbook in excel with monthly tabs and links form tab to tab. i.e. beginning balance in February pull from ending balance in January. When I copy a tab, say March to Create April, the new Tab will still link back to the February tab instead of the previous tab which would be March. So I go in to April and change all the links to March form February. Is there a way to set up the link so when I create a new tab using the copy function that the links will just refer to the the appropriate tab?
microsoft-excel
microsoft-excel
asked Nov 16 at 16:54
Chuck
1
asked Nov 16 at 16:54
Chuck
1
asked Nov 16 at 16:54
Chuck
1
asked Nov 16 at 16:54
Chuck
1
asked Nov 16 at 16:54
Chuck
1
1
1
Use one cell for storing the source worksheet name. Make all your references relative to it.
– Akina
Nov 16 at 17:28
@Akina it's a good candidate answer.. you should put it as full answer for this one.. you may throw an example to illustrate it. ( :
– p._phidot_
Nov 16 at 18:23
I'm lazy... sorry. And the solution seems is not difficult, the author can do it self I think...
– Akina
Nov 16 at 18:49
add a comment |
1
Use one cell for storing the source worksheet name. Make all your references relative to it.
– Akina
Nov 16 at 17:28
@Akina it's a good candidate answer.. you should put it as full answer for this one.. you may throw an example to illustrate it. ( :
– p._phidot_
Nov 16 at 18:23
I'm lazy... sorry. And the solution seems is not difficult, the author can do it self I think...
– Akina
Nov 16 at 18:49
1
1
Use one cell for storing the source worksheet name. Make all your references relative to it.
– Akina
Nov 16 at 17:28
Use one cell for storing the source worksheet name. Make all your references relative to it.
– Akina
Nov 16 at 17:28
@Akina it's a good candidate answer.. you should put it as full answer for this one.. you may throw an example to illustrate it. ( :
– p._phidot_
Nov 16 at 18:23
@Akina it's a good candidate answer.. you should put it as full answer for this one.. you may throw an example to illustrate it. ( :
– p._phidot_
Nov 16 at 18:23
I'm lazy... sorry. And the solution seems is not difficult, the author can do it self I think...
– Akina
Nov 16 at 18:49
I'm lazy... sorry. And the solution seems is not difficult, the author can do it self I think...
– Akina
Nov 16 at 18:49
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
In the April tab.. Do Ctrl + H > replace February! to March! > click replace all.
Not a beautiful copy paste solution. but if you don't rename your sheet and leave it as the original Sheet1 , Sheet2 ..
Then the use of =INDIRECT("Sheet"&(SHEET(A1)-1)&"!A1",TRUE) will be the copy paste solution you are looking for.
Hope it helps..
answered Nov 16 at 19:39
p._phidot_
48828
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
In the April tab.. Do Ctrl + H > replace February! to March! > click replace all.
Not a beautiful copy paste solution. but if you don't rename your sheet and leave it as the original Sheet1 , Sheet2 ..
Then the use of =INDIRECT("Sheet"&(SHEET(A1)-1)&"!A1",TRUE) will be the copy paste solution you are looking for.
Hope it helps..
answered Nov 16 at 19:39
p._phidot_
48828
add a comment |
up vote
0
down vote
In the April tab.. Do Ctrl + H > replace February! to March! > click replace all.
Not a beautiful copy paste solution. but if you don't rename your sheet and leave it as the original Sheet1 , Sheet2 ..
Then the use of =INDIRECT("Sheet"&(SHEET(A1)-1)&"!A1",TRUE) will be the copy paste solution you are looking for.
Hope it helps..
answered Nov 16 at 19:39
p._phidot_
48828
add a comment |
up vote
0
down vote
up vote
0
down vote
In the April tab.. Do Ctrl + H > replace February! to March! > click replace all.
Not a beautiful copy paste solution. but if you don't rename your sheet and leave it as the original Sheet1 , Sheet2 ..
Then the use of =INDIRECT("Sheet"&(SHEET(A1)-1)&"!A1",TRUE) will be the copy paste solution you are looking for.
Hope it helps..
answered Nov 16 at 19:39
p._phidot_
48828
In the April tab.. Do Ctrl + H > replace February! to March! > click replace all.
Not a beautiful copy paste solution. but if you don't rename your sheet and leave it as the original Sheet1 , Sheet2 ..
Then the use of =INDIRECT("Sheet"&(SHEET(A1)-1)&"!A1",TRUE) will be the copy paste solution you are looking for.
Hope it helps..
answered Nov 16 at 19:39
p._phidot_
48828
answered Nov 16 at 19:39
p._phidot_
48828
answered Nov 16 at 19:39
p._phidot_
48828
answered Nov 16 at 19:39
p._phidot_
48828
48828
add a comment |
add a comment |
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%2fsuperuser.com%2fquestions%2f1376047%2ftab-reference-links%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
1
Use one cell for storing the source worksheet name. Make all your references relative to it.
– Akina
Nov 16 at 17:28
@Akina it's a good candidate answer.. you should put it as full answer for this one.. you may throw an example to illustrate it. ( :
– p._phidot_
Nov 16 at 18:23
I'm lazy... sorry. And the solution seems is not difficult, the author can do it self I think...
– Akina
Nov 16 at 18:49