copy Tabs, based on two criteria in column J and paste values

Maybe:

Please Login or Register  to view this content.

What Tabs are you referring to ?

And You want to copy it where?

You do not have a sheet named destination and I am not sure if the 3rd is meant to be destination sheet.

I can't seem to work with this file sample. I don't know why? What suggestions did you get from the Code Cage? I'm guessing it may be close what I would offer. But I tried everything I know, my machine/application refuses to cooperate.

John,
If the error IS on this line.
As far as I know, you can not assign multiple range to a value, but you can the other way round.

Please Login or Register  to view this content.

In other words, you can assign the values 1 and 2 to more than cells, but it errors when you evaluate a range.
You need to loop through each cell and test it. That is from my expereince

Thanks for the insite AB33. But I tried several ways with the sample (including looping), and I couldn't get it to do anything other than filter the data.

John,
I used a loop (With out the fancy with statement and seems to work, please check the attached.

@AB33. You're right works perfectly.