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


Automatically creating worksheets based on a list in excel

  • jas ti
  • Topic Author
  • Offline
  • New Member
  • Mpya Mwanachama
1 month 1 week ago #1548 by jas ti

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