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
How to paste this down? 3
Section and Page numbering 0
How to make repeating drop-down lists? 2
Copy and Pasting with Macros 0
Pages are changing pasted image... 0
Copying Portions of Data 0
how to get a simple macro to paste value 4

Top