sql within a workbook

workin2def · Mar 7th, 2002, 04:11 PM

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 · Mar 7th, 2002, 06:50 PM

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[s]"

HTH. Cheers, Nate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 04:11 PM	#1
workin2def New Member Join Date: Mar 2002 Posts: 3	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!

Mar 7th, 2002, 06:50 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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[s]" HTH. Cheers, Nate