+ Reply to Thread
Results 1 to 2 of 2

how to link two workbooks when part of the filename change

  1. #1
    Registered User
    Join Date
    10-23-2008
    Location
    USA
    Posts
    64

    how to link two workbooks when part of the filename change

    Hello all!

    I have designed a workbook to track project resource. The idea is that for each project a copy of this sheet would be made by the project manager. The users will be saving their sheet as "Project Cost - xxxx' where 'xxxx' would be the project name. The idea is that, through validation (I can figure this out) overallocated resources will show in red thanks to a formula between the various workbooks. My issue is that the filename will always be different with the word "Project Cost -" being the only common elements. Any idea how proceed?

  2. #2
    Registered User
    Join Date
    06-14-2019
    Location
    Charlotte, NC, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: how to link two workbooks when part of the filename change

    If you are looking for a quick uncomplicated solution you can do the following:

    1) press CTRL + H
    2) Type the old file name in the 'Find what' field
    3) Type the new file name in the 'Replace with' field
    4) click on [Options]
    5) Change the 'Within' drop-down to "Workbook"
    6) click on the [Replace All] button

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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