POst some code, and we can help. We do not provide turn key solutions, but can help if you are stuck.
Have you recorded a macro doing what you want it to do? If not, I encourage you to r3cord a macro, then look at it to see how EXCEL VBA handles some different methods. Then make your code flexible with variables. POst back what you have so far!
It's kind of fun to do the impossible! -Walter Elias Disney