+ Reply to Thread
Results 1 to 3 of 3

Cell value based on sheet name - multiple values

  1. 04-23-2014, 02:59 PM #1
    bhola-bhala
    bhola-bhala is offline
    Registered User
    Join Date
    03-31-2006
    Posts
    9

    Cell value based on sheet name - multiple values

    I have values in Cells A15, B15, C15, D15 etc, which correspond to sheet names. I want to be able to update these values in these cells to automatically read the sheet names and update if names are changed.

    So
    Cell A15 will read the name of sheet #2
    B15 will read the name of Sheet #3
    and so on.

    Help plz
    Reply With QuoteRegister To Reply
  2. 04-23-2014, 06:12 PM #2
    Chance2
    Chance2 is offline
    Forum Contributor
    Join Date
    04-01-2009
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: Cell value based on sheet name - multiple values

    Try this...

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 04-23-2014, 08:22 PM #3
    Joakim N
    Joakim N is offline
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Re: Cell value based on sheet name - multiple values

    This code writes all sheet names (except sheet1) in workbook in row 15 in sheet1. It updates every time Sheet1 is activated.

    SheetNames.xlsm

    Please Login or Register  to view this content.
    1. Reply to thread and inform if suggestion was helpful or not
    2. Click on the star (=Add Reputation) if you think someone helped you
    3. Mark [SOLVED] to this thread if solution was found. (On Menu "Thread Tools" > "Mark this thread as solved")
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Multiple loops based on non-zero values and copy entire row to new sheet
    By nadiar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2013, 01:46 PM
  2. [SOLVED] Comparing cell values in different sheets based on multiple reference values as conditions
    By aknisha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2013, 02:41 AM
  3. search cell values based on list of values in other sheet and add color to row
    By darkbraids in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2012, 08:35 AM
  4. based on Cell/Column content ,cut one sheet's values and paste it in other sheet?
    By mindpeace in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2006, 08:33 AM
  5. based on Cell/Column content ,cut one sheet's values and paste it in other sheet?
    By mindpeace in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2006, 10:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1