Results 1 to 4 of 4
  1. #1
    JTHOM
    Guest

    Updating Links to worksheets that have tabs (Microsoft Office 98)

    I have a spreadsheet (A) that I use each month. It is linked to a workbook ([img]/forums/images/smilies/cool.gif[/img] that has a tab for each month. In January I want spreadsheet (A) to be linked to tab "Jan" in workbook ([img]/forums/images/smilies/cool.gif[/img]. In February, I want spreadsheet (A) to be linked to tab "Feb" in work book ([img]/forums/images/smilies/cool.gif[/img] and so forth. Each month I go in to spreadsheet (A) and change the link in every linked cell to link to the new tab name in workbook ([img]/forums/images/smilies/cool.gif[/img]. Is there a faster way that I can update all links to link to the currently indicated workbook, but the new tab title? If I go to "Update links" it shows the source workbook, which I want to remain the same, but it does not show that I am linked to a page within that workbook, which is what I want to change. Any help would be appreciated.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Links to worksheets that have tabs (Microsoft Office 98)

    Try find and replace, such as:

    Find
    Jan!

    Replace with
    Feb!

    Make sure the find isn't using "entire cell".

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Links to worksheets that have tabs (Microsoft Office 98)

    I'm not sure this would work, but it might be worth a try.

    I would name the worksheet in workbook B for the current month Current, and link spreadsheet A to Current. Then on the first of Feb I would rename Current to Jan and create my new Current.
    Legare Coleman

  4. #4
    JTHOM
    Guest

    Re: Updating Links to worksheets that have tabs (Microsoft Office 98)

    This seems to do what I need. Thanks so much

Posting Permissions

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