Dear Friends,
PFA
The base data is in worksheet Output.
Is their any macro which can do following steps.
e.g of "a"
1. Insert 2 columns after column F.
2. In D4, enter "Disc. Factor"
3. In E4, enter "Disc. Amt"
4. Merge C3, D3, F3
5. In C1, enter the formula till there is amt.
6. In C2, Enter the formula till there is amt.
7. In D5, enter the formula till there is amt.
8. in E5, enter the formula till there is amt.
Then goto "b",
Repeat the above steps.
Then for "c" and so on.... till there is value.
Please assist since there are many rows and many columns.
Doing this exercise manually is very time consuming.
Bookmarks