Hi Folks
I need to set up a scroll table with filtering capability.
In the attached (see Dashboard tab) you will see two tables, the lower one titled "List of Punch Items" needs to be able to look in the "Punch" tab and return the respective column values based on the value selected in cell (Dashboard!B3).
For example, if module M103 in chosen in B3, the punch table should only pull data relevant to this module.
Secondly, I need to add a filtering option from the drop down list in cell B24 that will filter for the different categories (Column H in punch tab). The attached has an example of what it should look like.
Thanks in advance.
Scroll Table & Filter.xlsm
Bookmarks