Splitting data into many workbook using a ID

Hi All,

I am trying to split data into many workbooks and wanted to know if there was an easy way to do it using VBA.

I have user's who have done journeys on many days and want to give each user a single workbook for all the journeys they've done (you can see this in my workbook). So ABAB, BCBC and CDCD all have their own workbooks. I do always have a list of all the user's before i start doing my report.

Am i able to get excel to split them out for me automatically as it is very inefficient breaking it down into workbooks everyday. I have tried running a macro but if i add a additional user, then the macro doesn't work correctly and it has come up with an error saying the macro is too long on many occasions.

I'd appreciate any help.