Hui,
I have been playing around with your suggestions. I am still finding it difficult to filter multiple tables using tables & pivot tables. Doing it for one table is not a problem
Typically i would have a list of tables like
EDI40
EDIDC
EDIDS
I want to get all index that relates to...
I am creating a excel workbook to do analysis on database tables and indexes. Normally I will download a dump of both tables & indexes an then categorize them.
Problem is that I want to separate tables and indexes using different sheets for each area. Currently I am using vlookup to extract...