Copy Cell (Only Value) to different Sheet's Cell

Your posts violate the rules of this forum. Please put your code in [CODE] tags if you want help. To do this, edit your posts, highlight your code, then press the # button in the text editor toolbar.

I've added [code] tags.

I assume that the macro is quickly jumping back and forth between sheets, before returning me to my first sheet. Is there a way to prevent that from happening?

Yes, with Application.ScreenUpdating, shown in code below. However, the way I wrote the code, it won't be of too much help here.

Anyway, a few things.

1. You don't ever really to do .Select. This is a human activity, and in VBA you can just work with the ranges directly. I've shown that in the code.
2. When copying just values, w/o formatting, it is my personal preference to just set the ranges equal to each other. I find it more straightforward.

The following is the functional equivalent of the second code set you posted. It is shorter, and IMHO, clearer.

Please Login or Register  to view this content.

Exactly what I needed. Thanks!