need a macro

  • Thread starter Thread starter april
  • Start date Start date
A

april

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
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Back
Top