I
Irvine, Dennis
I have a table of data in Sheet2.
Depending on a users input into Cell a1 on Sheet1, I would like to display,
on Sheet1, a subset of the data in the table in sheet 2.
so if a user inputs an "A" in Cell A1 on Sheet1, I want a list of data to
show up on sheet1 that is all the rows of data from sheet2 that relate to
"A".
I can do what I want by having a seperate workbook with the table data in it
and using an External Data query to bring in the data. But I can't query on
a table in the main workbook itself.
Being able to Query on External data, but not data in the open workbook
seems crazy to me, so I must be missing something.
Is there a way to query on a data table in one worksheet and have the
results show on another worksheet.
Thanks for any suggestions.
Depending on a users input into Cell a1 on Sheet1, I would like to display,
on Sheet1, a subset of the data in the table in sheet 2.
so if a user inputs an "A" in Cell A1 on Sheet1, I want a list of data to
show up on sheet1 that is all the rows of data from sheet2 that relate to
"A".
I can do what I want by having a seperate workbook with the table data in it
and using an External Data query to bring in the data. But I can't query on
a table in the main workbook itself.
Being able to Query on External data, but not data in the open workbook
seems crazy to me, so I must be missing something.
Is there a way to query on a data table in one worksheet and have the
results show on another worksheet.
Thanks for any suggestions.