macro to distribute the amount in date range

Hi everyone,

needed help in creating macro for below condition.

A B C D E CONCATENATE Valid From Valid to Amount
ABO1 KGW F97 C534 23 ABO1KGWF97C53423 02-03-2016 05-05-2016 20,400.00
ABO1 KGW F97 C534 23 ABO1KGWF97C53423 06-05-2016 31-12-2016 21,150.00
ABO1 KGW F80 C535 23 ABO1KGWF80C53523 02-03-2016 01-05-2016 20,325.00
ABO1 KGW F80 C535 23 ABO1KGWF80C53523 02-05-2016 31-12-2016 21,075.00
ABO1 KGW F97 C540 23 ABO1KGWF97C54023 02-03-2016 01-05-2016 20,400.00
ABO1 KGW F97 C540 23 ABO1KGWF97C54023 02-05-2016 31-12-2016 21,150.00


Note:
1 There will be a possibility of "additions" or "deletion" in columns in between "A" to "E".
2 And No of rows may "increase" or "decrease".

Output Needed
I want the Amount on date wise after fulfilling the Concatenate combination and valid date range.

A B C D E CONCATENATE 01-05-2016 02-05-2016 03-05-2016 04-05-2016 05-05-2016 06-05-2016 07-05-2016
ABO1 KGW F97 C534 23 ABO1KGWF97C53423 20,400.00 20,400.00 20,400.00 20,400.00 20,400.00 21,150.00 21,150.00
ABO1 KGW F80 C535 23 ABO1KGWF80C53523
ABO1 KGW F97 C540 23 ABO1KGWF97C54023
ABO1 KGW F65 C541 23 ABO1KGWF65C54123
ABO1 KGW F65 C850 23 ABO1KGWF65C85023
ABO1 KGW F65 C851 23 ABO1KGWF65C85123
ABO3 KGW F97 C534 23 ABO3KGWF97C53423

Note: Due to lack of space i have mention date till 07-05-2016 actually it will till 30.05.2016.

for your help i have pasted a partial macro which is created by friend.

Please Login or Register  to view this content.

Please do the needful.