Results 1 to 1 of 1

Generate sheets named after content of individual cells and insert link back to 1st sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2019
    Location
    Australia
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2404 Build 16.0.17531.20152) 64-bit
    Posts
    45

    Thumbs down Generate sheets named after content of individual cells and insert link back to 1st sheet

    Hi Guys,

    I'd like to find a way of generating sheets named after each of the following cells and enter a hyperlink back to 'Racking 1ST person'. The other sheets will be hidden, so you'll only see the 1st sheet unless you click on one of the cells, in which case it should appear and then disappear after you click 'Return to Racking 1ST person' link.

    I think I've figured out how to keep all sheets hidden and retrievable upon clicking on the associated cell but haven't been able to find a way to turn all of these cells into sheets automatically without doing it manually. Any help would be appreciated, cheers
    Attached Images Attached Images
    Last edited by ManateeProfanity; 05-03-2019 at 04:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto generate sheets using template sheet and upon data entry. Link to main sheet
    By Coubs3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2017, 09:48 AM
  2. How Do I Add A Link To Every Sheet that Links Back To My TOC?
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2016, 11:31 AM
  3. Have individual sheets link data into a final sheet in one workbook
    By nightstar430 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2015, 01:02 PM
  4. Generate messageBoxes over a range rather than individual cells to reduce code
    By mattbro in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-21-2012, 01:46 PM
  5. Replies: 1
    Last Post: 03-11-2006, 10:26 PM
  6. Replies: 2
    Last Post: 02-28-2006, 11:25 PM
  7. Macro to generate sequentially named sheets
    By Neil in forum Excel General
    Replies: 2
    Last Post: 09-03-2005, 05: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