see my above correction
sorry for the confusion


....Lisa

On Aug 7, 11:14 pm, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
Please check your addressing again. You say you have 650 addresses in 1300
rows. So I'm thinking
A1 = addr1 pt1
A2 = addr1 pt2
A3 = addr2 pt1
A4 = addr2 pt2
Which would use 1300 rows for 650 addresses. But you've tossed in column B
and C. I need a little better picture.

Maybe you have:
A B
1 addr1 pt1 addr326 pt1
2 addr1 pt2 addr326 pt2
3 addr2 pt1 addr327 pt1
4 addr2 pt2 addr327 pt2
... on down to row 650?

and how do you want them to end up arranged? All in just column C? In
which case it would be a simple matter of copying and pasting the two lists
end to end.

" wrote:
I have a 1300 row sheet of 650 addresses on 2 rows/1 column each (1st
address in A1, A2-----2nd address B1, B2, etc)

Right now I am copying the 2 cellsPaste SpecialTranspose

Is there a way to record a macro to do that?
Will that allow me to then click on the A1, then B1, then C1, etc and
run the macro using a single keystroke?

Or is there another better way?

I don't know VBA at all, though.

....Lisa