Thread
:
macro needed to copy blocks of cells across to list of cells down
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
macro needed to copy blocks of cells across to list of cells down
Perhaps a bit more info such as cell references, layout, etc.
--
Don Guillett
SalesAid Software
"piersonpro" wrote in message
...
I have a worksheet with blocks of cells containing names and address. They
are 5 cells across and 4 cells down. These blocks continue across the
sheet
quite a ways. I need to copy these blocks into a list that is 5 across a
continues down to end of list. using cut and paste would take a long time.
I
tried to record a macro but it won't move across to the next group to
copy.
Then it won't move down to the next blank field in the list to paste.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett