Openening a sheet with a selection set by a click on a row in a table
I would like to open a specific sheet based on the value of a cell in a table. For example if a column "AmountType" contains the values "Budget" and "Actual" and I click on a row where the value in "AmountType" is "Budget" I woould like to open the Budget sheet and select the value "Budget". Is this possible? How?