A great tool for Novices (and Pros alike) is the Macro Recorder.
If you turn on the Macro Recorder, and record yourself performing the Task manually, it will give you much of the VBA code you need.
Then just turn it off and view your code.
The caveat is that the Macro Recorder is very literal, so sometimes records things you don't really need (like screen scrolling), and can often be cleaned up a little.
It can usually also be made to be more dynamic with a few simple edits, if needed.
Give it a try, see how far you get, and if you run into any issues or need help "tweaking" the code, post back here to this thread with your code and question.
That's fine, but then you would need to indicate in the original that you posted a new thread on it (and post a link to it), so it does not get answered in both places (as there is a good chance that people may only see one of the questions and not both).
People sometimes get upset when they spend time developing a solution, and then come to find out that the exact same question has already been answered elsewhere in another thread. So we want to avoid that situation.