Move data from one sheet to multiple sheets

[aznan79]

Hi, i have a sheet (sheet named source) that contains hundreds of data and i would like to automatically create multiple sheet (eg. sheet named Aznan, ilyana & Nagor) using the data from the source sheet.

Column A contains Teacher names and other columns are their reservation details.

I would like to create sheets for each Teacher.

Attached is the sample spreadsheet. I would like to use the data sheet named "Source" to create the other sample three sheets (sheet named Aznan, ilyana & Nagor).

I would highly appreciate if anyone from the community could help.

Thanks in advance
Aznan

[AB33]

Try this one

Please Login or Register  to view this content.

[mike7952]

Try this

Please Login or Register  to view this content.

[AB33]

Mike! That is really great!
You came up with my fav topic of dic. I will go through it and ask you questions.

[aznan79]

Mike, AB33, thanks for the prompt reply guys, much appreciated, both code works.

Is it possible to also count the total number of rows on each of the newly created sheets ?

eg. "Total Records 4"

Please refer to the screenshot.

excel_count_records.jpg

Thanks in advance
Aznan

[mike7952]

Just replace the For Next loop at the bottom of the code with this

Please Login or Register  to view this content.

[aznan79]

Mike, it worked !!...thanks again for your prompt reply, very much appreciated.

One last request, is it possible to highlight the duplicates on Column D on each of the newly created sheets ?

Please refer to the screenshot below:-

highlightduplicates.jpg

Thanks in advance
Aznan Nagor

[mike7952]

Try this

Please Login or Register  to view this content.

[aznan79]

Mike, thanks again, it worked!!....you are a star mate!!

Regards
Aznan Nagor

[mike7952]

Your welcome, please mark your thread as Solved. Select Thread Tools-> Mark thread as Solved.

[jaydeep]

sir what will be the coding if somebody had to post azan illyena and nagor in sheet 1 of different workbooks rather than different worksheets of same wb

[jaydeep]

sir what will be the coding if somebody had to post azan illyena and nagor in sheet 1 of different workbooks rather than different worksheets of same wb

[jaydeep]

thanx its working

[mike7952]

@jaydeep,

As per forum rules Please do not post a question in someone else's thread. Please start a new thread.

[aznan79]

Mike, i tried again today with lots of data but the duplicates seems not being highlighted and i get the error that reads "Error #:13 Description: Type mismatch"

Your input will be highly appreciated.

Thanks in advance
Aznan

[mike7952]

Im guessing that one of the values in column A has an invalid characters in it like one of these ".", "?", "!", "*", "/", "", "[", "]", "‘", Chr(34), "|", "<", ">", "\", ":" or that the teachers name is longer then 31 characters. Give me a few and I'll fix that.

[mike7952]

Give this a try. if it still errors comment out this line On Error GoTo EarlyExit so the debugger will hightlight the error. And let me know what line is highlighted Yellow.

Please Login or Register  to view this content.

[aznan79]

Mike, thanks for your reply. Do you mean "Give me a few minutes" or "Give me a few examples of Teacher names" ?

Thanks in advance
Aznan Nagor

[mike7952]

I ment give e a few minutes. Have you tried the newest code? And read the post on what to do if it still errors?

[aznan79]

Mike, i have tried the newest code and i get "Error #: 9 Description: Subscript out of range"

Please help and thanks in advance
Aznan Nagor