I am having an issue Referencing/Copying/Linking (which would you say this qualifies under?) a Notes section from my Sheet1 to Sheet2.
The notes section is a series of merged cells H9 to H12.
My Formula is : ='U-Data'!H9:H12
This returns : #VALUE!
If I remove the merge from the cells H9 through H12 then just reference H9 in the formula it out-puts correctly. Only issue is the way the notes area will look for others that are using this same excel sheet in the future.
I like the notes area as a text wrap and multiple likes to fit in with the surrounding inputs, and I can not adjust the cell Height without causing an odd look to the input sheet(which is why I am using 3 merged cells).
Is there any way to get this merged cell text over to the output sheet2, or will I just need to redo my whole input sheet1 to allow for a single cell input instead of a merged cell?
Here is an image of the Input sheet:
The notes section is a series of merged cells H9 to H12.
My Formula is : ='U-Data'!H9:H12
This returns : #VALUE!
If I remove the merge from the cells H9 through H12 then just reference H9 in the formula it out-puts correctly. Only issue is the way the notes area will look for others that are using this same excel sheet in the future.
I like the notes area as a text wrap and multiple likes to fit in with the surrounding inputs, and I can not adjust the cell Height without causing an odd look to the input sheet(which is why I am using 3 merged cells).
Is there any way to get this merged cell text over to the output sheet2, or will I just need to redo my whole input sheet1 to allow for a single cell input instead of a merged cell?
Here is an image of the Input sheet:
