Create New Worksheets and Rename Them according to List in Another workbook

Hi everyone!

I'd like to create a macro that creates new worksheets based on a template called "Aircraft Survey Template" (basically copies this sheet) after the last sheet on my current workbook and renames it according to a list in another workbook called "Aircraft Tail No." The list in the other workbook begins from cell C3 but that list is constantly updated with new numbers if planes are added.

To summarise: I'd like the macro to create new sheets in my current workbook after the last sheet and rename them according to the tail numbers in the other workbook mentioned. If a sheets with the same name already occur in the current workbook then they should be left alone and not overwritten with the template "Aircraft Survey Template".

Any help would be greatly appreciated. Thanks!

Hi TMshucks!

I apologize for the lack of information. But I've attached sample workbooks with this post. Hope it helps. However,I did forget to mention a point in my previous post though. I'd like the tail number to also be copied to cell E6 in the new worksheet once it's renamed by the tail number. Thanks so much! Your assistance is greatly appreciated!

Regards,
Hackboss007

Originally Posted by LJMetzger

Hi Reuben,

Try the attached workbook. I used the 'Tail Number File' exactly as you posted.

There are 3 new command buttons on 'Sheet3':
a. Add new Tail Number Sheets.
b. Delete all Tail Number Sheets starting with 'N" (needed for s**tware testing).
c. Sort all Tabs (sheets) in ascending order (after ignoring the first 3).

Lewis

The code follows (independent ** all previous code):

Please Login or Register  to view this content.

NOTE: There is a problem with ExcelForuml.com on March 8, 2014 that universally changes all combinations ** 'o' and 'f' next to each other to '**'.
Administrators are aware ** the problem and are working on correcting the problem.

Thanks so much! This code works flawlessly!

Best wishes,
Reuben