i have multiple sheets of files and all have direct or indirect relationship and i want to filter out data from all using one sheet as a reference to look up from the remaining all.
ex. i have 15 sheets that have different information about a single object. I use sheet 1 as a reference and look up values related to that object from all 15 tables and show it in all 15 tables as filtered value by hiding the remaining values.
Copyright © 2020 | Truelancer.com