View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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.