You'll have to fix the formula in the code.

But you should save your work before you try it. Then if it doesn't work, you
can close without saving.

" wrote:

Dave,
Your right, it is weird...I had a typo. It should have read =if(a1="*
Rep Summary",d1,"").
I have not tried your solution yet.
If I change the typo, will your solution work or is there another
change that I need to make?

Thanks for everything

Hans

--

Dave Peterson