+ Reply to Thread
Results 1 to 6 of 6

Automatically Change Sheet Names Based On Cell Values - merged cells

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Automatically Change Sheet Names Based On Cell Values - merged cells

    Hi,

    This is my second post on this forum. I am new to VBA and Macros.

    I need to automatically change the sheet names based on cell values. The information in each worksheet is in a merged cell.

    Thank you

    Elizabeth

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Automatically Change Sheet Names Based On Cell Values - merged cells

    Hi,

    One way with the name you want for the sheet in question held in A1

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Automatically Change Sheet Names Based On Cell Values - merged cells

    Hello Elizabet, and welcome to the forums

    The volunteers who provide help on this forum are some amazing people with an astounding range of knowledge, as you monitor the forum and look at various threads and the responses you will see some brilliant results.

    Please take a moment to read the forum rules so that you have an idea of what is "good form"

    One tip that will help you get responses quickly is to always add into (see the *go advanced link at the bottom of this input panel) your posting a sample workbook that contains a clear example of your problem and the expected outcomes. As volunteers we (unfortunately) have a tendency to bypass requests that require us to second guess exactly what your spreadsheet looks like. Just remember this is a very public, worldwide forum so please ensure you do not have any sensitive or confidential data in your spreadsheet,

    In this particular case, it is a little unclear where the cell values are, is it a new sheet you are adding that you want named in a particular fashion etc.

    Have you tried to record a macro where you manually perform the actions to see what that provides as a "clue" to start with?

    IN your "pdf" question, do you want the whole page or a range withing the page turned into pdf.... the more info you can provide in each thread the more likely youa re to get a result


    Again, welcome to the forum on a sunny Melbourne day

    Jmac

    Cheers

    Jmac1947

    1. Please consider clicking on the * Add Reputation if you think this post has helped you
    2. Mark your thread as SOLVED when question is resolved

  4. #4
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Automatically Change Sheet Names Based On Cell Values - merged cells

    Hello Elizabeth, and welcome to the forums

    The volunteers who provide help on this forum are some amazing people with an astounding range of knowledge, as you monitor the forum and look at various threads and the responses you will see some brilliant results.

    Please take a moment to read the forum rules so that you have an idea of what is "good form"

    One tip that will help you get responses quickly is to always add into (see the *go advanced link at the bottom of this input panel) your posting a sample workbook that contains a clear example of your problem and the expected outcomes. As volunteers we (unfortunately) have a tendency to bypass requests that require us to second guess exactly what your spreadsheet looks like. Just remember this is a very public, worldwide forum so please ensure you do not have any sensitive or confidential data in your spreadsheet,

    In this particular case, it is a little unclear where the cell values are, is it a new sheet you are adding that you want named in a particular fashion etc.

    Have you tried to record a macro where you manually perform the actions to see what that provides as a "clue" to start with?

    IN your "pdf" question, do you want the whole page or a range withing the page turned into pdf.... the more info you can provide in each thread the more likely youa re to get a result


    Again, welcome to the forum on a sunny Melbourne day

    Jmac
    Last edited by jmac1947; 03-29-2014 at 08:20 PM. Reason: somehow it duplicated so I have tried to delete

  5. #5
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Re: Automatically Change Sheet Names Based On Cell Values - merged cells

    Hi,

    Please find the code in the sample workbook attached.





    Thanks!
    Moinuddin Shaikh

    If you like my Response:
    1. Show appreciation to those who have helped you by clicking "* Add Reputation" below their posts.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    Appreciate someone towards their career path is better than saying Thanks!
    -Moin
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-21-2014
    Location
    Seoul, Korea
    MS-Off Ver
    2013
    Posts
    1

    Re: Automatically Change Sheet Names Based On Cell Values - merged cells

    I am absolutely new to VBA and Macros. How do you automatically name a worksheet based on two cell values. One of the cells is merged and contains the name of the individual. The other has a data validation with the date format yyyy/mm/dd. I know some characters such as "/" in the date format maybe illegal. If it is, how would I code it so that it would change to this format yyyy.mm.dd. I want the worksheet to read "Name yyyy.mm.dd" for every worksheet in the workbook based on cell value inputs.

+ 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. change cell names based on new sheet name
    By tdebb8594 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2014, 02:25 PM
  2. [SOLVED] Sheet Change Event Dubuggin: Restrict Cell Values toand Changing cells based on input
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-28-2013, 02:37 PM
  3. Replies: 7
    Last Post: 11-25-2012, 01:24 AM
  4. automatically change cell value based on the value in other sheet.
    By star.dust9212 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-15-2011, 06:21 AM
  5. Automatically change Sheet names by typing in a cell
    By BLRITCHIE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2010, 04:19 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