My approach to this sort of thing is some VBA that, when invoked, modifies
then executes a query. Since it's in VBA, you have great flexibility in
using worksheet selections in updating the query. I'd generally invoke the
macro either with a button in the workbook, or from another macro that would
run though a list (for example, to generate commission statements for a team
of sales reps).
My problem is that I am using multiple queries, one per month for the next 10
years. I am try to find data between i.e '01-01-2009' to '02-01-2009'. Sine
I have 120 queries with only these dates changing I would like to link my
query to the column headers with the date ranges in the excel workbook. Is
this possilbe or do I have to learn VBA?
Ken
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
