R
Radu
Hi. I have on sheet 2 stuff like this:
Values Criteria
Value 1 1
Value 2 1
Value 3 1
Value 4 1
Value 5 2
Value 6 2
Value 7 2
Value 8 2
Value 9 2
I'd like on sheet 1 to be able to populate a combobox in a userform
only with the values coresponding to, say, criteria = '2'. I have build
the userform and all, but I don't know how to limit my RowSource to
only show the values for Criteria = '2'. Right now the rowsource is
smth like 'Sheet2!A2:A15', but this is not what I want.
Actually, I will need to be able to run much more convoluted queries
against the data. I could store the data in Access and run the queries
against that, but the target computer doesn't have Access, and,
besides, I'd like the user to be able to view/modify the data in
Sheet2, 3, etc, easily - the solution should be an 'All-In-One',
without using anything else than Excel.
Please, can you give me an idea on how to do this ?
Thanks, Alex.
Values Criteria
Value 1 1
Value 2 1
Value 3 1
Value 4 1
Value 5 2
Value 6 2
Value 7 2
Value 8 2
Value 9 2
I'd like on sheet 1 to be able to populate a combobox in a userform
only with the values coresponding to, say, criteria = '2'. I have build
the userform and all, but I don't know how to limit my RowSource to
only show the values for Criteria = '2'. Right now the rowsource is
smth like 'Sheet2!A2:A15', but this is not what I want.
Actually, I will need to be able to run much more convoluted queries
against the data. I could store the data in Access and run the queries
against that, but the target computer doesn't have Access, and,
besides, I'd like the user to be able to view/modify the data in
Sheet2, 3, etc, easily - the solution should be an 'All-In-One',
without using anything else than Excel.
Please, can you give me an idea on how to do this ?
Thanks, Alex.