Dear All,
I need assistance regarding the use of drop-down menus acting as switches to switch between data tables from other tabs within the same spreadsheet.
I hope this is clear. If not, here is an example of what I am after.
1. I have several drop-down menus set up as well as numerous tabs worth of data.
2. Using these I'd like to call data from different tabs. i.e Option A brings a table from sheet2 and is placed in sheet1 or Option B brings a table from sheet3 and is placed in sheet1
Any help would be amazing.
Steve
Bookmarks