Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what criteria needed to copy non blank cells to another location? | Excel Worksheet Functions | |||
Copying blocks of cells but the sizes don't copy | Excel Discussion (Misc queries) | |||
copy contents of multiple cells into a new cell - Help Needed Please | Excel Programming | |||
Need macro to copy a list of named cells between worksheets | Excel Worksheet Functions | |||
a script/macro to copy a block of cells next to specified cells | Excel Programming |