| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting Lines
Question
My boss wants Excel to automate the data coming out of MS Access. They have a listing of claims per month; each with a labor code and an Area code; labor code 123456789 could be a (area code)External Trim item; labor code 234567889 could be a Chassis (area code) item; etc. What they want is an Excel routine that, when it downloads from the Access database, sorts all of the claims by area code; Chassis, External Trim, etc'; inserts three blank lines between each grouping of all the claims within a given area code, subtotals all the claims within a given area code, then, puts the gross totals of the top 10 area codes on another spreadsheet, to allow the boss to type a few lines of text on what they are doing to fix it. They insist it be done in Excel; I said Crystal Reports or Access could probably do it easier, but I dont know neither Crystal Reports, nor Access Ideas? Replies to the newsgroup please; I no longer use this email address... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting Lines
wrote in message ups.com... Question My boss wants Excel to automate the data coming out of MS Access. They have a listing of claims per month; each with a labor code and an Area code; labor code 123456789 could be a (area code)External Trim item; labor code 234567889 could be a Chassis (area code) item; etc. What they want is an Excel routine that, when it downloads from the Access database, sorts all of the claims by area code; Chassis, External Trim, etc'; inserts three blank lines between each grouping of all the claims within a given area code, subtotals all the claims within a given area code, then, puts the gross totals of the top 10 area codes on another spreadsheet, to allow the boss to type a few lines of text on what they are doing to fix it. They insist it be done in Excel; I said Crystal Reports or Access could probably do it easier, but I dont know neither Crystal Reports, nor Access Ideas? Replies to the newsgroup please; I no longer use this email address... You could run a SQL query directly from Excel which would give you the data exactly as you want it. /fredrik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
| Borders/Inserting Lines | Excel Programming | |||
| Inserting a row after every seven lines | Excel Programming | |||
| Inserting Lines And Copying Them | Excel Programming | |||
| Inserting Lines | Excel Programming | |||
Hybrid Mode
