chappo555 wrote:
The macro came up with a run error ...

Hi chappo555

The macro works fine for me using the sample data and layout in your
original post. I can't get at your file to try the macro so can you
tell me where it's stopping?

Regards

Steve