I'm trying to recreate tabs for the same layout but different name.
The names are in cells i46:i92 in the current sheet.
Current tab name Marine.
Also I have a question. Could macro help me solve another problem when Im copying over the tab the Microsoft Excel window keep appearing asking
The name already exists. Click Yes to use that version of the name or click No to rename version of youre moving or copying.
Any way to solve this problem in the macro too ? If not I will have to use a stapler and leave my pc idle for a couple minutes