+ Reply to Thread
Results 1 to 3 of 3

Copy Sheet to Same Workbook but Update Hyperlinks to New Sheet Name

  1. #1
    Registered User
    Join Date
    07-05-2017
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    2

    Copy Sheet to Same Workbook but Update Hyperlinks to New Sheet Name

    Hi Community,

    I am desperate to get some help. I'm not an Excel fundi and have a serious issue. I created a sheet "Sheet1" and filled it with content. There are 100's of hyperlinks to the same sheet used for navigation. I have .png arrow all over the sheet to move to different places in the sheet, e.g. "Back to Top" etc. I did not know this would happen and there are a lot of links. I need to duplicate the page 12 times. It will take days to redo every for all 12 months of the year. I really need an easier way than manually changing every single image based hyperlink.

    Practically, I need a way to rename "Sheet1" to "January" and copy it to the same workbook for "February", "March" etc. - The issue is obviously as soon as I rename "Sheet 1" to "January" all the links display "Reference not Valid" as it is linked to "Sheet1". Also if I create a copy of "Sheet1" and name it "February" the links go back to "Sheet1" in the same workbook.

    There must be a way to link hyperlinks to new sheet name?

    I would really appreciate some help on this as I have a serious deadline and have been searing for a solution online for the last 7 hours with no success.

    Thank you in advance

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Copy Sheet to Same Workbook but Update Hyperlinks to New Sheet Name

    hi
    sorry if this is too late for your deadline
    it should be possible to do this with a macro. For example, this macro should change the links in the active sheet from "sheet1" to "January"
    if it doesn't work, could you give a bit more info on the sheets you want to link to and from, and the type of hyperlink used? If you could upload a workbook with some examples of what you want that would be even better

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-05-2017
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    2

    Re: Copy Sheet to Same Workbook but Update Hyperlinks to New Sheet Name

    Hi Nicky,

    Thank you, you are a star! I would go as far as saying you are a hero among ordinary folks! I truly appreciate you help!


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search and Update Relative Hyperlinks -When Sheet is Duplicated
    By sl729 in forum Excel General
    Replies: 1
    Last Post: 08-31-2016, 10:07 AM
  2. [SOLVED] Copy sheet from another workbook based on ComboBox names of the Workbook and sheet
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2016, 10:07 AM
  3. copy data from one sheet to annother, format it; Update to refect changes on source sheet
    By simplificated in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2013, 03:45 PM
  4. [SOLVED] macro to copy rows from a sheet in one workbook to a sheet in a different workbook...
    By fredderf81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2013, 01:36 PM
  5. Find Hyperlinks, Copy Hyperlinks to alternative sheet, print all hyperlinks
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 05:13 PM
  6. Replies: 7
    Last Post: 12-03-2012, 03:10 AM
  7. Hyperlinks and opening any sheet a workbook
    By Angelo Battistoni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1