Hi,
I have a formula which works as a hyperlink in a cell at the moment:
=IF(A22="","Enter Procedure Above",(IFERROR(HYPERLINK("#"&@CELL("address",INDEX('AWC2'!1:1,MATCH(A22,'AWC2'!1:1,0))), "Link to Procedure "&A22), "Procedure Not Found")))
I would like to create a button (I'm ok with this part) but I would like to insert the formula above in that button so when I click on it, it takes me to the right place calculated by the formula. I know nothing of VBA.
Thank you for your help.
I have a formula which works as a hyperlink in a cell at the moment:
=IF(A22="","Enter Procedure Above",(IFERROR(HYPERLINK("#"&@CELL("address",INDEX('AWC2'!1:1,MATCH(A22,'AWC2'!1:1,0))), "Link to Procedure "&A22), "Procedure Not Found")))
I would like to create a button (I'm ok with this part) but I would like to insert the formula above in that button so when I click on it, it takes me to the right place calculated by the formula. I know nothing of VBA.
Thank you for your help.