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.