Hi guys!
I have 10 sheets in an Excel workbook.
The data on these sheets are imported from ODBC through 10 different Microsoft queries.
Now the 10 queries share a same parameter, the time period, such as <#2016/3/31#.
Every time I want to run these queries, I need to open each one and modify the period parameter.
Is there a way to input the time period parameter in an cell or record a macro so that I can simply click a button to have all the queries use this parameter?
thanks for your help :)
Bookmarks