Results 1 to 22 of 22

Add new worksheets depending on a list with predetermined names

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-11-2013
    Location
    Sweden
    MS-Off Ver
    MS 365
    Posts
    188

    Add new worksheets depending on a list with predetermined names

    Hi all,

    I donīt have the knowledge to create this by myself so im hoping for your great help again, if this is possible.

    I have a workbook with two sheets, "Start" and "RefTab". I need a macro that adds or delete sheets depending on how many numbers there are in a list in sheet "RefTab. I also need that the new sheets are named Cabin 1, Cabin 2 up to the number in the list.

    I would like every new sheet to be a copy of "Start" sheet, except that one specific cell (B6) need to have the same number as the number of the sheet. So if I have Cabin 10 i need B6 to be 10, and in Cabin 17 B6 should be 17. When I start a new project there may be a shorter list, fewer cabins. So if possible I need the macro to delete sheets named Cabin XX if they are a bigger number then the listnumber.

    Is this possible? I sure would be very grateful!

    Hope you understand what i am trying to achieve. Please se attached file.

    /Masun
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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