Seems to me the best way to start, if you don't already know VBA, is to start recording a macro; then do all the actions you want included, while the recording mechanism "watches". When you're done, stop recording, and look at the macro that Excel created. You'll have to modify it from there to make it more general; we'll have to talk about that.

I expect you'll have questions. Do you know how to record a macro? Once you've recorded a macro, do you know how to find and display it? And once you're looking at the macro instructions, do you have any programming background that will help you understand how it works?