Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a column of single cells into a column of merged cells
I am trying to copy a column of single cells on one worksheet into a
column of merged cells on an adjacent worksheet- does anyone have any methods of achieving this? I tried formulas, but the referencing gets messed up and in the merged cells it only displays every fourth entry from the column of single cells. Any help would be appreciated. Claire |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a column of single cells into a column of merged cells
One way using VBA would be to read all the data into an array and then dump
the array into the destination cells. Might not be the best solution for larger files though. Cheers, Scott " wrote: I am trying to copy a column of single cells on one worksheet into a column of merged cells on an adjacent worksheet- does anyone have any methods of achieving this? I tried formulas, but the referencing gets messed up and in the merged cells it only displays every fourth entry from the column of single cells. Any help would be appreciated. Claire |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
Copying cells with similar column values | New Users to Excel | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |