Copy Variable Values to another sheet for Matching Values

Please Login or Register  to view this content.

The item being searched (what) is Cells(I,32) on the Working Sub sheet because that is active. You need to add reference to the other sheet if that is what it should be. Ditto in lines below, add a sheet reference to be safe, or use With:

Please Login or Register  to view this content.

Thanks,

I'm still struggling to get the values to copy.
Something still is not right that I'm overlooking.
I will have to play with this later.

Any other inputs appreciated.

Thanks.

Try explaining in plain English what you're trying to do. Even better, attach a small sample workbook.