Two queries in one workbook sharing input-variable values??

Question: Hi all,
Is is possible to have two queries in one workbook where the user first refreshes query1 and then when refreshing the other query, query2, the input-value for a variable (for example costcenter) entered when refreshing query1 should automatically be used as input for the costcenter variable in query2???

Best regards,
magado

Answer:
if you use refresh all queries in workbook this is automatically done

Answer:
Many thanks!
Copyright ?2007 - 2008 www.jt77.com