|This additional requirement will take a little time. This is not as simple a fix as just changing a column like you asked for in your first change request.|
Allow me to offer a posting tip...
When asking for help in a forum such as this, you should gather all of your requirements before posting.
The solutions offered typically require the setting up of a test workbook, then the writing of code and then the testing of the code. Each time you come back to the forum with more and/or different requirements, we usually end up having recreate the test environment, modify the code and then retest it.
I am now into the 3rd round of set up and testing since you have changed your requirements twice.
Imagine if this help was not free. Imagine if you hired a consultant, gave them your requirements, and then kept changing them each time they presented a solution that met the previous set of requirements. Imagine your boss not being happy as the consultant kept billing him for each change request.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.