Hi All,
Need some help with this.
I have a database which has historical tables within it and i want to be able to pull several different tables into one sheet.
I need to know if there is vb code which can pull data with the same query against several different tables into one sheet in excel to then use as a data sheet for further manipulation in pivot tables?
at the moment i am only able to pull back one table at a time and i have about 60 to do.
Thanks for any help on this one.
Bookmarks