So let's say I have A1, B1, and C1 on my sheet1, and I am referencing those cells in sheet2.
In some cases A1 and B1 are merged, and in others they are not. Is there any way on sheet2 to program it, not just to reference sheet1!A1, but also to keep the format of A1, including if that means merging with B1 on sheet2?
I hope the question makes sense.
Bookmarks