macro to copy and paste special on another page if criteria is true

[jamief]

Hi,

Another probably super simple one for ya.

Everything in this macro is working really well, the only thing that I want to change is for it to paste only values. I've been googling the answer and it says you have to have the copy and paste as two separate lines, but I don't really know what the paste line should show as to make everything work.

Please Login or Register  to view this content.

Thanks!

[Trebor76]

Hi jamief,

Try this:

Please Login or Register  to view this content.

I've also added code to find the last cell in Col. A of "Source" tab instead of arbitrarily just using 1,000 rows and toggled screen updating.

Regards,

Robert

[jamief]

Perfect, Thanks Robert!

[Trebor76]

Thanks for letting us know and marking the thread as solved