Splitting the big table into smaller ones

[Stanoje]

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 post a SS because can't use mini-sheets via mobile phone)

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


Thanks in advance.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to split the table into smaller pieces ?
and Splitting the big table into smaller ones

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.