I was trying to create a macro that went to several workbooks then to
a specific worksheet did an autofilter on a specific field the copied
and pasted those into a new work book. The paste of the selection
will be dynamic. I can give a specific cell destination for the paste
in a new work book. Do you have a macro that does something similar
in which I could tweak the code??

If you do I will be up a little while.