+ Reply to Thread
Results 1 to 2 of 2

Change name of current sheet using cell value

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Change name of current sheet using cell value

    Good morning

    I am creating a template worksheet that will be duplicated numerous times in the future, and i want to be able to use a cell reference to change the name of the worksheet rather than manually renaming the sheet each time.

    So in the attached example .... if i have a value in cell A1 that i can choose from a data validation list, i then want the sheet name to reflect the same as is in this cell.

    I am assuming a short VBA code would be the best approach, and that it would need to be triggered on changing that sells value?
    If anyone has any idea it would be much appreciated.

    The aim is to create the sheet in a way that I can duplicate it (as a master) and then as I change the cell value it renamers the sheet.
    Attached Files Attached Files
    Handy things to keep in mind:

    Click *, if my suggestion has helped you
    If your problem is solved, then please mark the thread as SOLVED

    Sharing is Caring .... spread the knowledge

  2. #2
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Re: Change name of current sheet using cell value

    LOL .... ** Cell's ** not sells !!!!!!

+ 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. Current Sheet Tab name change to text in cell a1
    By robrobet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2013, 11:22 AM
  2. Change CURRENT CELL
    By bobptex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2012, 06:15 PM
  3. [SOLVED] How can I delete source links and change the current sheet accord.
    By Marshanann in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-16-2005, 10:40 AM
  4. [SOLVED] Change Cell Color if in current Month
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Change Cell Color if in current Month
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

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