I like using the Import External data wizard for creating my macros.

1) Start Recording a macro from worksheet menu Tools - Macro - Record New
Macro
2) Import Data from worksheet menu Data - Import External Data - Mew Web
Query or New Database Query. Select the options you want from the wazard
menues. The last menu where you select finish you can use the Query Editor
to see the SQL statements by select Edit Query
3) Stop Recording from worksheet menu Tools - Macro - Stop Recording.


You can now edit the recorded macro as required.

"Cesar" wrote:

Hello,
I'm retrieving data from SQL and creating a table from, lets say, columns
A:E, the first column contains a product serial number (unique) and the
following columns have the cost of diferent chemicals used on the product
fabrications, lets say, ChemA, ChemB, ChemC and ChemD. Using a Combo Box
looking at the column A for the ListFillRange, I select a product from the
list and put it on the cell F1(LinkedCell). What do I need to do to copy all
the cells (Chems) that belong to that particular chosen product?, in other
words, I want to copy all the Chemicals used for that product from cell F1 to
F5?

Thanks
--
Cesar