I currently have two tabs on my spreadsheet, "List" & "Template".
• I would like to create a macro that creates a new worksheet based upon a list of information (names and last names) in the "List" tab starting with cell B3 and ending with cell B183.
◘ The macro would select the contents in cell B3 from the "List" tab,
◘ create a new worksheet,
◘ rename the new worksheet to contents of "List" B3,
◘ copy the "Template" worksheet,
◘ paste the "Template" in the new worksheet (that is now renamed from "List" cell B3).
◘ And add the contents of B3 from the "List", to the newly created worksheet (in a specified place),
◘ and then continue on to cell B4 and so on...