Create workbooks from unique values

Hello everyone
I have a task that I desperately need to complete so Any help in the correct direction is appreciated.
I have written the code below to create new workbooks based on column k in master sheet and save them in the path of the active workbook.
The code works fine but I am having problem in Two points
first point is how can create new workbooks with the beginning 11 columns and the columns from ED to GL based on the column k
The second point is how can insert total row to sum for each column in the workbooks created.
Here is what I currently have in my Module

Please Login or Register  to view this content.

Thank you in advanc

try

Please Login or Register  to view this content.

Thank you so much Jindon - this worked.
What about the second point which is how can insert total row to sum for each column in the workbooks created.
Thanks again for your support,

Ahhh,

try replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Thanks again Jindon! I will check and get back to you.

Thanks sintek! I will check and get back to you.

Dear Mr Jindon
Note : The range I want to sum is in columns L through BT in the workbooks created .... I will test it again
You can modify this line of your code

Please Login or Register  to view this content.

Thank you for your patience.

Code in #9 has been edited.

Thanks Jindon and sintek! Both macros works wonderful! Appreciate your help.
I have two extra questions to ask:
1 - How can Add some formats for columns from L to BT like Number Format Etc in the workbooks created.
2- How can change the row height for this row that contains "Total" to 60 points and the main header in row 1 too to 120 points.
Thanks a lot for both of you to help me

Please Login or Register  to view this content.

Please Login or Register  to view this content.

So, you are happy to remove hyperlinks in Col.K.

Please Login or Register  to view this content.

I'm not happy to remove hyperlinks in Col.K.... but I'm very very happy for sharing me my issues.
I am so glad of this perfect solution ... Thank you very much jindon ... You are a true legend...Have a Great Day

Then need to copy the rows.

Use whichever faster.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you very much jindon
I tested it on Another sample about 12000 rows ( Not tested on the original file ) Here's this report
Sub test() In post #13 = 8 seconds
Sub testAutoFilter() In post #15 = 17 seconds
Sub testDic() In post #15 = it is painfully slow it takes about 7 minutes to execute.
Again my sincere thanks for taking an interest in my problem.

Yep, code in #13 uses AdvancedFilter and it is not actually copying the rows (removing hyperlinks etc.), so faster...

Thanks again jindon for all the great help you offered
Give me some time to work on the original file and I will tell you about any notes.
see you tomorrow ... Have a nice time my Professor

Thank you very much sintek
It works well ... it took about 10 seconds
but I need to som formats in all workbooks Which will be created .... please refer to #post 12
Again my sincere thanks for taking an interest