This is hard for me to explain to me let alone to you, so good luck and thanks in advance for considering solutions.
I'm using Excel 2007.
This question is not quite code based, I'm more looking for ideas on what direction I should try to go with the code, focussing on efficiency.
From an SQL Query I get a table like this showing me who the owners are of my CMDB items:
I want to select a name via drop down list and display all owners of all items of which the selected person is an owner.
eg. If I select "Edward Teach" it will lookup all items linked to Edward and display all rows for those items and I would get this result:
I'll have 1 button to run the SQL Query and import the data. (I have already written the code for that). After that I don't want the spreadsheet constantly looking at the database, I want it to only use what has already been imported.
I will probably add to the data import script the creation of an alphabetized list of a unique names on a seperate worksheet to use for the Drop Down list. That should be easy enough.
But I need ideas on how to go about this double filter.
Here is my current concept. Can you offer a more efficent method for me?
Upon selecting a name it could run some sort of lookup and physically create/replace a table showing all Config_Items associated with the name. Then it could use the data from that table to do a standard multi entry autofilter.
I've not previously tried initiating a macro from a drop down selection. I think I can or perhaps I'll need to add a [Search] button that will actually run it.
Bookmarks