sql within a workbook

[workin2def]

hey, I have a database on sheet3....names, numbers, unitname, etc. Now, On sheet1 I have a cell(A12) that I want to type in the unit name and have it place the all records that have that unit name from sheet3 and place them on sheet1 in rangeA14 on sheet1.
do anyone know of a vb code to do so. thanks!

 

[NateO]

Is it an Access Database?

If so, establish your link to the database and record a macro where you "refresh" the data. Add this to code where you update your "paramater"


HTH. Cheers, Nate