Use of Sql within Excel code

Hi

I think I need to use SQL in my VB code as I want to drill through from one spreadsheet to open a new sheet based on criteria from the first.

So for example, lets say a had a hidden sheet with all the "detail", and my main sheet had 100 records, showing the total spend for each one of 100 schools. Then if I was to click on a school name, a new sheet would open and show the details (lets say spend per month) for that particular school.

Would an Sql string in the code be the way to go?

Many thanks

Ronan

It seems to me you could use a pivot table on your data. In a pivot table, you can do exactly what you describe. Look into this. If you need help, can you attach a sample file?