hi,
i have a set of numbers which run something like this
Excel 2007<br
My Amount count will go to thousands..., How can i write a macro so as it will shown the sum of Amount 2 with corresponding figures in Amount1, and a row inserted after every sub total (matched).......... say..... something like this...(while those unmatched can be sorted in any manner)
Excel 2007
I will be greatly obliged, if u can provide some kind of help to this. Thanks in anticipation excel gurus. (I posted earlier but couldnt express me properly as i had not used HTML maker.. hence resubmitting with HTML)..please excuse my ignorance.
Cheers
i have a set of numbers which run something like this
| Excel Workbook | ||||
|---|---|---|---|---|
| A | B | |||
| 4 | Amount 1 | Amount 2 | ||
| 5 | $2000 | |||
| 6 | $111 | |||
| 7 | $622 | |||
| 8 | $5000 | |||
| 9 | $200 | |||
| 10 | $4300 | |||
| 11 | $1800 | |||
| 12 | $600 | |||
| 13 | $2000 | |||
| 14 | $500 | |||
| 15 | $1200 | |||
| 16 | $2000 | |||
Sheet5 | ||||
My Amount count will go to thousands..., How can i write a macro so as it will shown the sum of Amount 2 with corresponding figures in Amount1, and a row inserted after every sub total (matched).......... say..... something like this...(while those unmatched can be sorted in any manner)
| Excel Workbook | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 18 | Amount 1 | Amount 2 | |||
| 19 | $5000 | $200 | |||
| 20 | $4300 | ||||
| 21 | $500 | ||||
| 22 | Subtotal | $5000 | $5000 | ||
| 23 | |||||
| 24 | $1800 | $600 | |||
| 25 | $1200 | ||||
| 26 | Subtotal | $1800 | $1800 | ||
| 27 | |||||
| 28 | $2000 | $2000 | |||
| 29 | Subtotal | $2000 | $2000 | ||
| 30 | |||||
| 31 | $622 | ||||
| 32 | $111 | ||||
Sheet5 | |||||
I will be greatly obliged, if u can provide some kind of help to this. Thanks in anticipation excel gurus. (I posted earlier but couldnt express me properly as i had not used HTML maker.. hence resubmitting with HTML)..please excuse my ignorance.
Cheers
