Results 1 to 29 of 29

Have the sheet name automatically change in a formula

Threaded View

  1. 08-29-2018, 09:51 AM #1
    CLSSY56
    CLSSY56 is offline
    Forum Contributor
    Join Date
    10-11-2007
    Location
    St Louis MO
    MS-Off Ver
    365 (v16.53) for Mac
    Posts
    179

    Have the sheet name automatically change in a formula

    I'm new to this, so please don't beat me up too much....

    I am wanting to automatically change the tab names in a formula when I copy the cells down to another row.

    The formula that I'm using is
    Formula: copy to clipboard 
    ='01'!$C$4
    where the sheet name is 01.

    If I add another tab, and name it 56, could that formula automatically change?
    Last edited by CLSSY56; 08-29-2018 at 05:12 PM.
    -Travis
    Mac OS 12.1
    Excel 365 (v16.59)
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can I change sheet tab name automatically?
    By sudbhavani in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-12-2017, 10:07 AM
  2. code change data from sheet 1 will be automatically copied to sheet 2 with conditions
    By hacke.r in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2015, 09:38 PM
  3. [SOLVED] Automatically change sheet number when first sheet is filled in.
    By Bikeman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2014, 04:36 PM
  4. change data automatically from one sheet to another
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2011, 03:39 PM
  5. Automatically Change Sheet Tab Name With Date in Cell
    By chrisneu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2011, 11:34 PM
  6. How do I change the sheet a formula refers automatically?
    By able72 in forum Excel General
    Replies: 2
    Last Post: 11-23-2005, 08:18 PM
  7. [SOLVED] Automatically run macro on sheet change
    By Steven in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2005, 07:21 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1