Creating/Naming New Worksheets Based on Select Cells in Master Worksheet

L

Lilbit

I have a worksheet which lists each officer and the accounts they manage.
Thanks to Adilson Soledade I was able to create worksheets and name them
according to cells created from filtering the unique values of the IO
column which contains the officer names on the main worksheet.

Sub CreateWorksheets()
Dim i As Integer
Dim WSheet As Worksheet

Set WSheet = ActiveSheet
For i = 4068 To 4106
Worksheets.Add After:=Sheets(ThisWorkbook.Sheets.Count)
ActiveSheet.Name = WSheet.Cells(i, 1)
Next i
WSheet.Select
End Sub

However, I've learned that this is only part of the project. I have now
been told that each worksheet created for each officer should list only
their accounts. Is there a macro for this? If yes, how do I get my hands
on it. Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy row 2 of any wsheet to the new crated wsheet 6
Auto worksheet name? 1
Auto worksheet name? 1
shorten worksheet name 1
Excel crashes and restarts when accessing newly created worksheet 2
shorten sheet name 4
Automatically insert code into worksheet via macro 0
Create multiple Pivots based on list of parameters 4

Top