it now seems that I might be able to use SQL/MS Query to do what I tried to find a workaround. (Even if this works that does not invalidate the problem posed in that thread, though its urgency would be reduced.)
So: is there a way to perform in a macro SQL queries on data coming from the same workbook?
Say, take the data from several different ranges as if they were SQL tables, perform some SQL queries (like GROUP BY, SORT BY etc.) and return the result in a chart, all from and to the same datasheet!
I tried to open a connection from an Excel file to itself as if it were an external database, only to be told by the Wizard that it does not contain any tables. And I don't know whether this is a problem within the Excel file or due to it trying to connect to itself.
Thanks a lot!
P.S. I should add that I have never worked with MS Query or any other way used SQL in Excel.
Edited 5 Years Ago by Alba Ra: Added Postscript