+ Reply to Thread
Results 1 to 3 of 3

Name a cell after a sheet name

  1. #1
    Registered User
    Join Date
    09-17-2019
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    11

    Question Name a cell after a sheet name

    Good Morning,
    I have a workbook of 30 pages.
    On sheet 1 Cell B1 needs to have the name of sheet 2 nametab at the bottom of the excel sceen.
    &
    On sheet 1 Cell B2 needs to have the name of Sheet 3
    On sheet 1 Cell B3 needs to have the name of Sheet 4
    And so on for 30 sheets

    im looking for something like =STRING(Sheet1!$name$) I know that doesnt exist but its just a way
    of explaining myself. I hope its not too confusing.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Name a cell after a sheet name

    This is what you are looking for: https://www.howtoexcel.org/tips-and-...k-without-vba/
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    09-17-2019
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    11

    Re: Name a cell after a sheet name

    Fantastic.

    Thank you

+ 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. [SOLVED] syntax to select cell in another sheet based on offset of active cell in current sheet
    By duvius in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-07-2014, 11:16 AM
  2. [SOLVED] read single cell content from sheet of closed file and put it in a cell on an active sheet
    By rsmith5413 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2014, 04:16 AM
  3. Replies: 2
    Last Post: 11-18-2013, 07:31 AM
  4. [SOLVED] Locating a cell in sheet 2, based on 2 variables in sheet 1. Result into sheet 1.
    By Gezza24 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-05-2013, 12:50 AM
  5. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  6. Replies: 13
    Last Post: 04-04-2012, 01:25 AM
  7. Replies: 1
    Last Post: 10-30-2009, 10:58 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