Try turning on the Macro-Recorder and going through all the steps, including
running the Queries and the copy and pasteing one more time and then turn off
the Macro-Recorder and see how close you get.

hth
Vaya con Dios,
Chuck, CABGx3



"Ken" wrote:

Hi!

I am trying to copy some data (27 columns & 42 rows) from Worksheet "A" to
Worksheet "B" for about 17 times. First, I run MS Query in Worksheet A; then
paste query data as value on worksheet B. The pasted data on Worksheet B
will be adjacent to each other row after row. I repeat the steps with
different query result for about 17 times. I am wondering if there is Macro
for these repeating steps.

Thank you very much!

Ken