G
Guest
Hi All
I am trying to create a Macro that places sub totals in a column of data.
The data is imported from a RTF file and already has sub totals in place in
bold font.
These are obviously just a number. There a couple of other issues making
this difficult though.
1. each block of data may or may not be contigous There may be gaps
2. each block of data is dynamic and may change in amounts and number of
rows,etc
3. No adjoining column has a unique set of identifiers which I could use to
do a DATA / SUBTOTALS search.
4. The data range is approx 400 lines * 7 columns and may change in size at
any time.
See example data below :
Any assistance would be greatly appreciated
Regards
Michael M
QUANTITY UNIT RATE TOTAL
1 lump 12,000 12,000
1 lump 2,000 2,000
1 item 121,440 121,440
60 week 1,400 1,400
219,440 BOLD FONT
Blank Line
Blank line
1 kg 12,000 25,000
1 day 2,000 6,000
1 month 121,440 100,600
60 week 1,400 400
131,700 BOLD FONT
I am trying to create a Macro that places sub totals in a column of data.
The data is imported from a RTF file and already has sub totals in place in
bold font.
These are obviously just a number. There a couple of other issues making
this difficult though.
1. each block of data may or may not be contigous There may be gaps
2. each block of data is dynamic and may change in amounts and number of
rows,etc
3. No adjoining column has a unique set of identifiers which I could use to
do a DATA / SUBTOTALS search.
4. The data range is approx 400 lines * 7 columns and may change in size at
any time.
See example data below :
Any assistance would be greatly appreciated
Regards
Michael M
QUANTITY UNIT RATE TOTAL
1 lump 12,000 12,000
1 lump 2,000 2,000
1 item 121,440 121,440
60 week 1,400 1,400
219,440 BOLD FONT
Blank Line
Blank line
1 kg 12,000 25,000
1 day 2,000 6,000
1 month 121,440 100,600
60 week 1,400 400
131,700 BOLD FONT