OK,

Here is what I am trying to accomplish: I have a large worksheet I am working with and I am working on a macro to select certain cells that meet a specific criteria and copy and paste those cells only into another worksheet. I have the select and paste part down but how to I enable it to assign a condition? For example, I would like the macro to select all the cells that contain 99 in the front of the number of one column and copy those cells into another worksheet. Can someone please point me in the right direction? Thanks in advance.

-Dave