How to find and sort and copy A through J, K through M, etc. from fixed range

[Jeddo]

I am looking for a way using VBA or macro to search a range and find all of the last names that begin with A through J, K through M and so on and copy those names to another range so I can print it out. Thanks

 

[CyrusTheVirus]

You could try power query. Ever used it? Do you know if you have it?

 

[Jeddo]

You could try power query. Ever used it? Do you know if you have it?

Never heard of it and not sure if I have it. I'm using Office 2010