Hello Mentors,
Here I had a question and my scenario is this.
I have multiple sheet and workbook, now I have to connect all workbook and sheet with eachother as like they are one database. Now I need to fetch data from that whole interconnected excel files from one place, and get a specific results ( whatever I am searching for or looking for).
Example: I have five workbook and each contains 3-4 sheets. Now i have interconnected all workbook and sheets making that they are one database.
Now I will search for particular keywords or item and it will show me results of that item.
Is it possible to do this. If yes, please guide me.
Thanks
For this I tried to make all workbook and sheets data on single sheet.
Now how can I make multiple dependent filters list so that I get specific results.
Bookmarks