+ Reply to Thread
Results 1 to 2 of 2

create non-repeated worksheets (copy of template) with hyperlinks from main list

Hybrid View

  1. #1
    Registered User
    Join Date
    02-18-2015
    Location
    USA
    MS-Off Ver
    2007
    Posts
    1

    create non-repeated worksheets (copy of template) with hyperlinks from main list

    I need a macro that creates new worksheets named from a master list on the "Summary" worksheet. Each new worksheet will be a copy of a template. There also needs to be a hyperlink created from the original cells in "Summary" that links to the new worksheet. This macro needs to be able to be run more than once if additional cells are added to the Summary list and, if so, will NOT create new worksheets that have already been created (or list an error saying there already exists such a worksheet)--it will only add new worksheets (and hyperlinks) from the newly added cells on "Summary."

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: create non-repeated worksheets (copy of template) with hyperlinks from main list

    Hi, helpwanted222,

    sample workbook wanted. And information if any sheets should be deleted if they are no longer listed.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for 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] Create Multiple Worksheets from a template using the names in a list
    By gsemaan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2012, 02:24 AM
  2. Replies: 3
    Last Post: 06-24-2012, 02:01 AM
  3. Macro to create worksheets and transport data from Main list
    By LMoir in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-11-2012, 12:03 PM
  4. Replies: 2
    Last Post: 02-06-2012, 07:39 PM
  5. Create copy of multiple worksheets and automatically fill in data from a main sheet
    By NMChemEng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2008, 05:28 PM

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