D
Dave
Not sure how to ask this; haven't found anything on the problem. I'd
like to create a source range (E2:BD3) on one sheet and have the same
area on four other sheets match it cell for cell. The source range
contains 12 merged cells. Every year I have to break some of them up
and reconfigure the number of cells that make up some of the merged
ones. I'm wondering if ranges would be a solution. I would allow for
the possibility that altering the merges would mess up a range by
including some blank cells at the end. These sheets perform a calendar
type of function, so some years a merge contains 4 cells across a
column (4 weeks), other years it's 5.
like to create a source range (E2:BD3) on one sheet and have the same
area on four other sheets match it cell for cell. The source range
contains 12 merged cells. Every year I have to break some of them up
and reconfigure the number of cells that make up some of the merged
ones. I'm wondering if ranges would be a solution. I would allow for
the possibility that altering the merges would mess up a range by
including some blank cells at the end. These sheets perform a calendar
type of function, so some years a merge contains 4 cells across a
column (4 weeks), other years it's 5.