Hello,
I am trying to make a macro to replace some of my formulas. The one I am having trouble with is the following formula:
='Stratum 2'!$AP$77&(IF('Stratum 2'!$AQ$77="- ","",(IF('Stratum 2'!$AR$77="- ",("; "&'Stratum 2'!$AQ$77),("; "&'Stratum 2'!$AQ$77&"; "&'Stratum 2'!$AR$77)))))
Any suggestions on how to write this as a macro. What it does is brings together 3 cells into one, but only those that are populated. THe first cell is always populated, whereas the other two may not be.
Thanks.
I am trying to make a macro to replace some of my formulas. The one I am having trouble with is the following formula:
='Stratum 2'!$AP$77&(IF('Stratum 2'!$AQ$77="- ","",(IF('Stratum 2'!$AR$77="- ",("; "&'Stratum 2'!$AQ$77),("; "&'Stratum 2'!$AQ$77&"; "&'Stratum 2'!$AR$77)))))
Any suggestions on how to write this as a macro. What it does is brings together 3 cells into one, but only those that are populated. THe first cell is always populated, whereas the other two may not be.
Thanks.