hello there. im working with a dataset and i have a table that needs to be hidden/shown based on a dropdown option cell value from another sheet and im not sure how to write this.
Basically i have a cell with dropdown options "xxx" and "not xxx" on sheet 1. one sheet 2, there is a table that needs to be shown if "xxx" is selected in the dropdown, or hidden if "not xxx" is shown in the dropdown. can someone help with this. the issue im running into is not know how to reference different sheets in 1 macro.
Basically i have a cell with dropdown options "xxx" and "not xxx" on sheet 1. one sheet 2, there is a table that needs to be shown if "xxx" is selected in the dropdown, or hidden if "not xxx" is shown in the dropdown. can someone help with this. the issue im running into is not know how to reference different sheets in 1 macro.