Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

Create a new Blank Sheet for each value in a List

Good Afternoon

I am looking to create a new blank Sheet for each value, from A2 on a Sheet named Data. The indication to stop creating new sheets is a blank cell in the A column.

Regards
0
Washcare
Asked:
Washcare
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Sub gensheets()
For Each cel In ActiveSheet.Range("A2", Range("A2").End(xlDown))
ActiveWorkbook.Sheets.Add
ActiveSheet.Name = cel.Value
Next cel
End Sub
0
 
WashcareAuthor Commented:
Many thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now