How to split the table into smaller pieces ?

Hello everyone,


I have been looking but haven't found how to transport data from one big table to more smaller ones. In specific - I want to split it into more smaller pieces.

I manually did it so you can see what I want to do automatically:

Thanks in advance.

Stanoje said:

Hello everyone,


I have been looking but haven't found how to transport data from one big table to more smaller ones. In specific - I want to split it into more smaller pieces.

I manually did it so you can see what I want to do automatically:

I want to separate this bigger table into smaller ones by the same criterias (name;surename) ?


​

Thanks in advance.

Click to expand...

Bump!
Sorry, it's urgent.

For others considering responding to check if a satisfactory solution has been offered elsewhere, this topic has been cross posted without links:
https://www.mrexcel.com/board/threads/splitting-the-big-table-into-smaller-ones.1179266/
https://chandoo.org/forum/threads/splitting-the-big-table-into-smaller-ones.46768/

Stanoje, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

It would be an idea to supply an actual Excel workbook rather than a picture of one.