Can anyone help?????
I have three drop down boxes on a spreadsheet that are linked to three tables imported from Access.
In Access these boxes are linked so that I can pick on the first one and dependant items in the second and third boxes are loaded. They are selected in Access by the SELECT DISTINCTROW()statement.
Having now imported the three tabls into Excel how do I now get the dropdown boxes to work the same as in Access.
I hope this is not to to confusing,
A QUICK REPLY WOULD BE MUCH APRECIATED