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







share|improve this question


















  • 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















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







share|improve this question


















  • 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













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







share|improve this question













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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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














  • 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










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..






share|improve this answer





















    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    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',
    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
    });


    }
    });














     

    draft saved


    draft discarded


















    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

























    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..






    share|improve this answer

























      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..






      share|improve this answer























        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..






        share|improve this answer












        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..







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 16 at 19:39









        p._phidot_

        48828




        48828






























             

            draft saved


            draft discarded



















































             


            draft saved


            draft discarded














            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





















































            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







            -

            Popular posts from this blog

            Plaza Victoria

            Image
            Plaza Victoria Plaza Victoria en 2017 Otros nombres Plaza de La Victoria Localización El Almendral, Valparaíso, Chile Vías adyacentes Chacabuco, Molina, Plaza Victoria y Edwards Creación 1841 Metro Bellavista Ubicación 33°02′46″S 71°37′11″O  /  -33.04624167, -71.61980833 Coordenadas: 33°02′46″S 71°37′11″O  /  -33.04624167, -71.61980833 [editar datos en Wikidata] La Plaza Victoria , también llamada Plaza de la Victoria , [ 1 ] ​ es una plaza ubicada en el sector El Almendral del plan de la ciudad de Valparaíso, Chile, de importancia patrimonial, que incluye valiosas estatuas y especies vegetales. [ 2 ] ​ La plaza se creó como tal en la primera mitad del siglo XIX, tomando previamente los nombres de Plaza Nueva y Plaza de Orrego . Si bien desde sus inicios tuvo relevancia histórica, no fue sino a partir de fines de los años 1860 cuando comenzó a cobrar mayor importancia y se convirtió en uno de los principales centros sociales de l
            Read more

            In PowerPoint, is there a keyboard shortcut for bulleted / numbered list?

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 OneNote has two useful keyboard shortcuts for bulleted and numbered lists, namely Ctrl + . and Ctrl + - . Is there something similar for PowerPoint where the work with lists is also very common? Haven't found anything here: Use keyboard shortcuts in PowerPoint. keyboard-shortcuts microsoft-powerpoint share | improve this question edited Aug 14 '14 at 14:49 Linger 2,826 10 28 40
            Read more

            How to put 3 figures in Latex with 2 figures side by side and 1 below these side by side images but in...

            Image
            1 0 I want to put 3 images in LateX such as 2 figures are side by side horizotally and 3rd figure below these 2 side by side figures but in middle. I have following code: begin{figure}[H] centering begin{minipage}{.5textwidth} centering includegraphics[width=.50linewidth]{Text/Images/Genelec_8010_AP.jpg} captionof{figure}{Genelec 8010 AP} label{fig:Genelec 8010} end{minipage}% begin{minipage}{.5textwidth} centering includegraphics[width=.69linewidth]{Text/Images/Genelec_8020_CPM.jpg} captionof{figure}{Genelec 8020 CPM} label{fig:Genelec 8020} end{minipage}% end{figure} %%Here is my 3rd picture code begin{figure} centering includegraphics[width=5cm]{Text/Images/Genelec_8030_BPM.jpg} caption{Genelec 8030 BPM} label{fig:Genelec 8030} end{figure} I want to ask ho
            Read more