The three cells you mention are all on the same row.........row 16

So what do you really want done?


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 12:37:01 -0700, Scott
wrote:

I am trying to write something that will copy data from CJ16:CO16 down to the
last row with a value in CQ16. I would like to paste this into a new sheet
(sheet two) any help?