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.