P
Patti
Hi!
I have a lovely file with numerous worksheets and five
parameter queries. The queries use different tables and
fields, but they all have the same parameter criteria,
Month and Year. When I hit "refresh all", I have to enter
the parameters five times. Is there a way to only enter
them once? The month and year exist on the "summary"
sheet in cells M1 and N1 -- is it possible to run the
queries with a macro by referencing these cells?
Thanks!
I have a lovely file with numerous worksheets and five
parameter queries. The queries use different tables and
fields, but they all have the same parameter criteria,
Month and Year. When I hit "refresh all", I have to enter
the parameters five times. Is there a way to only enter
them once? The month and year exist on the "summary"
sheet in cells M1 and N1 -- is it possible to run the
queries with a macro by referencing these cells?
Thanks!