How do I create a macro to run queries with worksheet data

Hi. I am trying to create a macro that will use data points from my worksheet to fill in the fields in a query and then return the data that this query yields to a specified location in my worksheet.

For example, I have a long list of zip codes that my company serves, but we don't have the neighborhood and city information. I wish to be able to put all these zip codes in one column, run the macro and have it return all the neighborhood, city and state info into the three cells to the right of this column and then skip down to the next row and do the next zip code. I have a number of websites that will provide me with the neighborhood, city and state information, but I want a time-effective way of retrieving the data and organizing it into excel without a lot of data entry.

Any words of wisdom would be much appreciated.

Thanks
Josh

perhaps use the vlookup or hlookup?

coudl you explain a bit more perhaps an example workbook that one could play with or understand what you require?

select list with vlookups thens just so many ways of achieving what you want.