James Perry
Member
I'm in sheet1 that is renamed 'ExpenseMaster'.
In this sheet some 20 cells have been randomly selected.
Each cell has the name of an 'Expense Item' like:
Conveyance
Entertainment Expense
Biz Travel
and the like.
If i click on 'Conveyance' in the Master, i would like the 'click' to 'trigger-off'
the opening of the sheet named 'Conveyance' (in the same workbook).
Ditto for the remaining expense items.
What Excel formula/s can achieve the same?
Thank you. Much appreciated.
In this sheet some 20 cells have been randomly selected.
Each cell has the name of an 'Expense Item' like:
Conveyance
Entertainment Expense
Biz Travel
and the like.
If i click on 'Conveyance' in the Master, i would like the 'click' to 'trigger-off'
the opening of the sheet named 'Conveyance' (in the same workbook).
Ditto for the remaining expense items.
What Excel formula/s can achieve the same?
Thank you. Much appreciated.
Last edited:
