Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need a macro
Sorry that i can't be more explicit. but here is the problem. i have
downloaded a report from another software into Excel. the other software's report is VERY confusing. Row 1 Col A shows the account code, 50921.1, and in Col C the total budget for that code (12,000) Row 2 is blank Row 3 has the phrase [Entity] Budget Detail ic col A and Year Sum in Col D Rows 4, 5, 6 / Col a has the detail that make up that 12,000. Col D in those rows shows the amount of each detail. Row 7 has the total Row 8 is blank Row 9 Col A shows the account code, 50950.1 and in Col C, the total budget for that code. Row 10 is blank Rows 11 and 12 show the detail Row 17 Col A shows the Total for the account category that accounts 50921 and 50950 are part of. in short (please excuse this long explanation), the total of a code (not a category) shows at the top. i would like the report to look like this: NACDS conference 4,400 Inlt Pharem Conf 2,000 HDMA conf 5,600 50921 - Conference expense 12000 Printing for conf 1,500 Business Cards 100 50950 - Printing 1600 T5070 Promotional Expenses 13,600 THE REPORT AS IT APPEARS NOW Col A Col C Col D 50921.1 Conference Expenses 12,000 [Entity] Budget Detail Desc. Year Sum [01.1.04.0000.000] NACDS Conference 4,400 [01.1.04.0000.000] Int'l Pharm Conference 2,000 [01.1.04.0000.000] HDMA Conference 5,600 Total 12,000 50950.1 Printing & Publishing 1,600 [Entity] Budget Detail Desc. Year Sum [01.1.04.0000.000] Printing for HDMA & HIDA conferences 1,500 [01.1.04.0000.000] Business Cards 100 Total 1,600 T5070 Promotional Expenses 13,600 i know that i can cut and paste, but would sure appreciate a better way, as i have many of these reports to prepare. thanks in advance for your help -- aprilshowers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) |