macro needed to copy blocks of cells across to list of cells down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Don Guillett said:
Perhaps a bit more info such as cell references, layout, etc.
Click to expand...
Don,

Thank you for the reply.
The list I need to copy to is from cell A1 to E1 and continues down. The
blocks I mentioned that need to be copied are adjacent to the list and
separated by 1 blank column between each block. These blocks continue across
the sheet (about 50 blocks).
 
I guess I still don't understand. If desired, you may send to me, at the
address below, a sample workbook, copies of these messages and EXACTLY what
you want.
 
Back
Top