I am attempting to copy groups of columns and then paste their contents over columns with similar formatting while preserving formulas in hidden rows on my destination sheet. I have been successful in copying ranges of cells including only the visible cells,
(using this process: Select the whole range of cells -including the hidden ones. Go to Edit>GoTo>Special>VisibleCellsOnly.
Copy and paste.)
but now I wish to paste those same cells on only visible cells. Any help or ideas would be greatly appreciated. Thank you,
Bryce
(using this process: Select the whole range of cells -including the hidden ones. Go to Edit>GoTo>Special>VisibleCellsOnly.
Copy and paste.)
but now I wish to paste those same cells on only visible cells. Any help or ideas would be greatly appreciated. Thank you,
Bryce