Hi all,
I have a workbook with multiple sheets (unfortunately due to vast amount of data I have to keep sheets separate).
The only unique column is the ID column in column A between sheets.
My goal is to be able to filter sheet 1 (the master sheet) based on columns B onwards: the IDs that are shown are then subsequently filtered in sheets 2 and 3 (even though they display different variables).
If anyone has any tips or solutions to this I would greatly appreciate it!!!
Bookmarks