And I don't think it's close to the longest thread.

Even with this response! <vbg

Andre Croteau wrote:

Hi Again Dave,

I believe this must be close to the record number of threads....

I have a final(?) question regarding the original code:

The original code works well, but I would like to copy/PasteSpecialValues
from any of the 3 sheets to the "Summary" sheet

Your code has a straight "Copy / Paste" procedures, so that formulas are
also copied, which is not always the best thing to do.

Is there one last line code you can change/modify?

Thanks in advance, and also for the answer to my other question

André

<<snipped