Copy and paste up to values in last row

S

Scott

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?
 
D

Don Guillett

-- last row with a value in CQ16.
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy table to new sheet 5
Copy and paste to the last row 3
Copy and Paste Macro 1
Copy and paste to the last Row of columb A 6
copy/paste row with one formula 6
Still Another Copy-and-Paste Macro Problem 3
Paste Values in linked Cells Only 4
Cannot copy worksheet to another file 2

Top