The usual approach is to use static SQL in a stored procedure on the
server side and get the client to pass parameter values.

--

Sauron wrote in message ...
Cheers man, really grateful!

The only problem is that other cells can be chosen instead that's why I
broke it down into a series of IF statements because it wouldn't work
if I used a static query, it needs to build based on which cells are
typed into. Hope that's enough info!

Cheers Very Much!
Sau


---
Message posted from http://www.ExcelForum.com/