baleman2
asked on
Microsoft Query, Excel Spreadsheet modification
We have a 3rd party software program with an embedded Microsoft Query utility. We use this utility to pull data from a Sybase database and export the data to an Excel spreadsheet.
Our company consists of 10 separate used car dealerships. Our initial query displays data in "Sheet 1" of an Excel Workbook. The query presents cumulative data for ALL 10 dealerships spread across several columns in the spreadsheet, such as:
Column 1 - Branch #
Column 2 - Automobile Unit #
Column 3 - Automobile Make
Column 4 - Automobile Model
Column 5 - Automobile Mileage
Column 6 - Dealership Purchase Price
Column 7 - Bank Loan Value
and on and on.
Once this spreadsheet dislplays the data for ALL dealerships on "Sheet 1", we can then use the "sort / filter" dropdown windows to display this same data for just ONE branch. However, after the "sort / filter" occurs it redisplays the newly sorted data on the same "Sheet 1" of the Excel Workbook.
What I would like to do is continue to see the initial query results for all 10 dealerships on "Sheet 1" of the Workbook. I would like to automate the process of "sort / filter" for Branch 1 and display that data on "Sheet 2" of the Workbook. I would like to automate the process of "sort / filter" for Branch 2 and display that data on "Sheet 3" of the Workbook. I would like to automate the process of "sort / filter" for Branch 3 and display that data on "Sheet 4" of the Workbook . . . and so on.
The Excel Workbook would ideally display results from the initial query on "Sheet 1" and each of the next 10 worksheets of the Workbook would display data pertinent to ONLY 1 dealership in our group as described above.
If it would help, I have a SQL statement available that correctly produces the data for all 10 dealerships in "Sheet 1" of the Excel Workbook.
Our company consists of 10 separate used car dealerships. Our initial query displays data in "Sheet 1" of an Excel Workbook. The query presents cumulative data for ALL 10 dealerships spread across several columns in the spreadsheet, such as:
Column 1 - Branch #
Column 2 - Automobile Unit #
Column 3 - Automobile Make
Column 4 - Automobile Model
Column 5 - Automobile Mileage
Column 6 - Dealership Purchase Price
Column 7 - Bank Loan Value
and on and on.
Once this spreadsheet dislplays the data for ALL dealerships on "Sheet 1", we can then use the "sort / filter" dropdown windows to display this same data for just ONE branch. However, after the "sort / filter" occurs it redisplays the newly sorted data on the same "Sheet 1" of the Excel Workbook.
What I would like to do is continue to see the initial query results for all 10 dealerships on "Sheet 1" of the Workbook. I would like to automate the process of "sort / filter" for Branch 1 and display that data on "Sheet 2" of the Workbook. I would like to automate the process of "sort / filter" for Branch 2 and display that data on "Sheet 3" of the Workbook. I would like to automate the process of "sort / filter" for Branch 3 and display that data on "Sheet 4" of the Workbook . . . and so on.
The Excel Workbook would ideally display results from the initial query on "Sheet 1" and each of the next 10 worksheets of the Workbook would display data pertinent to ONLY 1 dealership in our group as described above.
If it would help, I have a SQL statement available that correctly produces the data for all 10 dealerships in "Sheet 1" of the Excel Workbook.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just the resulting workbook with single sheet.
This we can then split off into separate sheets for each dealership.
This we can then split off into separate sheets for each dealership.
ASKER