I have two sheets with formulas like the following.
=IF(Slct_Report=1,HWF!B12,AWF!B21)
=IF(Slct_Report=1,HWF!B9,AWF!B10)
I'm trying to write a macro to remove the 'if' statement so that I get:
=HWF!B12
or
=AWF!B10
based on the value of Slct_Report
Thanks very much for your help...
Bookmarks