Knowing what to search for is sometimes the most challenging part of finding something!
I'm working on an Excel spreadsheet that needs to "peek" into a SQL database to populate some cells. I've got the first two set, however now I'm looking at building out the Excel/SQL equivalent of a multi-selects related, per row. Here's what I'm trying to accomplish: 1. User keys a SSN 2. Excel pulls an employee ID, name and company code from the SQL database. I have this working using VBA. 3. Excel populates a list for the user to select three different data points from (call them Location, Department and job title). These are stored in multiple tables in the database but I already have the query to pull them in. 4. Based on the Job title, Excel pulls a dollar amount from the SQL database to go into the next table. 5. Based on the department, Excel pulls a "participation" number (will be either a percentage or a dollar amount) to apply to the dollar amount pulled in #4. 6. A formula is applied to the numbers pulled in #4 and #5 to provide some breakdown. I've gotten the connection working with VBA, know the query/queries I need to write, the problem I'm having is figuring out what to search for to have a dynamic named list per row that is dependent on values entered or selected in other cells. At this point I've searched for quite a few variances but haven't found anything similar to multi-select-related per Excel row. Any suggestions on how to word #3 so the search engine stops throwing me to the wolves? Thanks! Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:362319 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
