Hello,

I have a spreadsheet with multiple rows and columns per tab and multiple tabs. I have hidden many of these rows and columns along with the majority of the tabs except for two. I would like the view to stay the same for the user but at the top of my spreadsheets, I have data validation lists that if the user chooses a different drop down option, the totals will update.

Is there a way to keep these rows, columns, and tabs hidden but still allow the user to utilize the drop down validation list and the totals will still update?

Thanks,
Hector