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
Bookmarks