Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Automatically creating worksheets based on a list in excel

  • jas ti
  • Topic Author
  • Offline
  • New Member
  • Membre nou
More
1 month 1 week ago #1548 by jas ti
Hello

Please help me


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...



Please tell me if this can be done

Thank You

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo