I have one workbook with a summary sheet, an 5 to 7 input sheets (asset register) that I want to be able to select a dropdown on the summary sheet for say the branch and the workbook automatically filters all the input sheets by branch entries (all branches are included per asset category per input sheet) so that the summary sheet only reflects the Branch data.
In addition it must also go back to the global information, if say "ALL" is selected.
Have researched some VBA options, but is there no Excel button or add on that can do this? And what VBA options are out there?
In addition it must also go back to the global information, if say "ALL" is selected.
Have researched some VBA options, but is there no Excel button or add on that can do this? And what VBA options are out there?