sujittalukde
Well-known Member
- Joined
- Jun 2, 2007
- Messages
- 520
I need a macro which will copy the row containg the word "Carried over" and paste it to next row as "Brought Forward" However if below the Carried over, the word "Grand Total" exist, then no such copy paste is required.
A sample shot is given below for better understanding.
In case some more clarification required, do let me know.
A sample shot is given below for better understanding.
In case some more clarification required, do let me know.
CarriedOverBroughtFwd.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Names | Amount | ||||
2 | a | 3 | ||||
3 | b | 4 | ||||
4 | c | 5 | ||||
5 | Carried over | 12 | This is the page sub total | |||
6 | Brought Forward | 12 | This is the copy of above row containing "carried over" | |||
7 | e | 9 | ||||
8 | f | 8 | ||||
9 | g | 7 | ||||
10 | Carried over | 24 | This is the page sub total | |||
11 | Brought Forward | 24 | This is the copy of above row containing "carried over" | |||
12 | h | 7 | ||||
13 | i | 4 | ||||
14 | j | 3 | ||||
15 | Carried over | 14 | This is the page sub total | |||
16 | Grand Total | 50 | Since below the Carried over, grand total so no | |||
17 | paste value is required from above row | |||||
Sheet1 |