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 |
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 |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com