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

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.

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.

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

"Don Guillett" wrote:

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.



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).

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

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.

--
Don Guillett
SalesAid Software

"piersonpro" wrote in message
...


"Don Guillett" wrote:

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.



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).