Dave,

Thanks for the help...but how would I go about placing this in VBA?
Currently I do this via formulation and when I send out I copy paste
into another workbook. The reason I want to convert to VBA is that I
can send out the actual workbook and stop the double work.
As for your "Watch Out"; I didn't state it plainly. If "* Rep Summary"
does not exist in cell A1, do nothing. Does that help in explaining
what I need it to do?

Thanks,

Hans