I have 3 sheets in an Excel spreadsheet.
Sheet 1 is the summary sheet which I will describe later.
Sheet 2 contains hundreds of rows of data with an ID field in column A
Sheet 3 contains hundreds of rows of data with an ID field in column A
The summary sheet should have as cell where the user types in an ID value. It then has two further cells showing the count of rows in sheet 2 and sheet 3 with that value in their ID column (A).
So far I can do it, now comes the problem. Once the user has typed the ID value on sheet 1, if they click on sheet 2 or 3 the records displayed should be filtered to only show those with the selected ID.
At the moment they have to filter each sheet manually which apparently is not acceptable.
Can you filter a set of rows on one sheet based on a value in a cell on another sheet?