Rerunning queries automatically after export

Drfox3

New Member
Joined
Mar 15, 2011
Messages
7
Has any one ever set up a query that, after running and exporting the results to an Excel spreadsheet, runs anew based on a set of values in a table in the database?
Example below;
Table A has one field with values 1 -> x.
Query B runs, taking the first value from Table A
Query B finishes, exports to Spreadsheet A
Query B starts over, taking the next value from Table A.
Sequence repeats itself until the last value in Table A is used.
You are left with Spreadsheet A -> X
Table A is not the sole source of data for Query B
I hope I made this clear enough, if not let me know.
 
Last edited:

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Drfox3

New Member
Joined
Mar 15, 2011
Messages
7
Thanks, I posted the same question on both sites hoping to have a response from either. Answers on the other site have not been helpful. They told me what I should do but not how to do it.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top