Dear Jerry,

There are a lot of materials on the internet that teach vba. It is just for you to google.
I will look at the second part of your request asap. I kinda busy please bear with me.

Kunle