Yes, it works! Fantastic! How do I copy this VBA to another workbook?

Paul

Hi Paul

Just open both workbook. Press ALT-F11 to display the VBA screen. Drag Module 1 from your current workbook to the new workbook.

You can also copy the code and paste it to the new workbook.

Sunny

Thanks, Sunny. Works great now. I can't thank you enough--it has saved me hours of tedious work. I could conquer the world if I knew VBA. I must learn how to do this. Perhaps MyOnlineTrainingHub offers a course.

Paul

Hi Paul

I am happy to know it is working for you. VBA is definitely the way to go if you want to "conquer the world", as you put it.

I am sure MOTH would have some courses to help you improve on your Excel skills.

Sunny