+ Reply to Thread
Results 1 to 2 of 2

Template Duplication Formula - Please help

  1. #1
    Registered User
    Join Date
    06-11-2024
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    1

    Template Duplication Formula - Please help

    Hi There,

    I'm hoping someone can help me. I have two workbooks; one which is a master workbook and the other which I'm going to duplicate a number of times based on a template.

    The template has the following formula:

    ='[AVAILABILITY SPREADSHEET MASTER.xlsx]Devon'!X4

    "Devon" represents one of the tabs in the master workbook which also has many other tabs with different names such as "Apollo" and my current challenge is that every time I duplicate my template, I then need to manually change "Devon" to "Apollo" and so on.

    I would like to be able to have 1 cell in the template sheet called "Devon" which I can change to "Apollo" which would then change all other formulas such as the above that have "Devon" in it. The cell reference in the template sheet to change would be U1.

    Thank you for your help,

    David

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,926

    Re: Template Duplication Formula - Please help

    You would normally use the INDIRECT function to do this.

    However, that function does not work with closed workbooks, so you would have to ensure that the Master workbook is open, as well as the duplicated file. Is that something you could guarantee to happen?

    Hope this helps.

    Pete

+ 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. Stopping duplication of a INDEX formula
    By rg268 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-29-2023, 07:35 AM
  2. [SOLVED] TRUE / FALSE result - ROW Duplication / Duplication in ROW
    By Sherwood_2022 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2022, 06:07 PM
  3. Replies: 3
    Last Post: 11-20-2020, 01:09 PM
  4. Formula to avoid duplication of results
    By Nobleks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2019, 12:51 PM
  5. [SOLVED] Help with Duplication formula please!
    By cstahlhut in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2012, 09:07 PM
  6. Formula for data duplication between excel sheets?
    By Johnz414 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2008, 04:49 PM
  7. Replies: 3
    Last Post: 03-03-2007, 10:41 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