T
tmdrake
I have a database that exports the results of a query into a Excel
Spreadsheet. I am trying to build a marco that convert this information into
a Pivot Table. The only problem is the row count changes everytime you run
the query and the information is exported into Excel.
My questions is there a way to write the marco, so that it automatically
adjust to the number of rows that are exported from the database?
All help is greatly appreciated.
Spreadsheet. I am trying to build a marco that convert this information into
a Pivot Table. The only problem is the row count changes everytime you run
the query and the information is exported into Excel.
My questions is there a way to write the marco, so that it automatically
adjust to the number of rows that are exported from the database?
All help is greatly appreciated.