Sorting export Data

Hi

Thank you for the reply again.

I have ran the VBA version which is my prefered method which worked great for a small team. When I try to upscale this to a much larger team the dates are not placed in the top row? on the first loop they get placed in row 28? They are also not consistently separated?

Do you know how I can upscale the macro to work for teams that consist of over 200 people?

Any further help that you can give would be really appreciated.

Thanks again

D