Hi,
I have a working formula in Excel that allows me tohyperlink to other cells within my worksheet by clicking a specific cell. Iwould like to assign that formula to a button because frankly, using a buttonlooks much more professional than clicking a cell. This is the formula that Iwant to assign to the button:
=HYPERLINK("#"&CHOOSE(MATCH($B$2,{"Apple","Banana","Pear","Grape"},0),"D6","D57","D108","D159"),"GO")
Any ideas?
Thanks!
I have a working formula in Excel that allows me tohyperlink to other cells within my worksheet by clicking a specific cell. Iwould like to assign that formula to a button because frankly, using a buttonlooks much more professional than clicking a cell. This is the formula that Iwant to assign to the button:
=HYPERLINK("#"&CHOOSE(MATCH($B$2,{"Apple","Banana","Pear","Grape"},0),"D6","D57","D108","D159"),"GO")
Any ideas?
Thanks!