Hi there,
Is it possible to make other worksheet to reflect data according to master worksheet when filter specific parameter?
Let me explain in details:-
I have "Master" worksheet contain all information
I have worksheet "B", "C" and "D" which contain other information, but each worksheet have one similar information that exist in "Master" worksheet (example Barcode)
What I want to do is, when I filter a barcode (or any criteria) in "Master" worksheet. The other worksheet (B, C and D) will automatically show data with the same barcode (or criteria) only, without I need to filter manually in every worksheet.
Thank you
Regards,
Nurul
Bookmarks