need help in creating macro

[ncpavan08]

Hi everyone,

[FONT=arial, sans-serif]Is it possible to create a macro for below.

[/FONT]

Note: 1 There will be a possibility of "additions" or "deletion" in collums in between "A" to "E". 2 And No of rows may "increase" or "decrease". <tbody> </tbody>
Output Needed ; I want the Amount on date wise after fullfilling the combination and valid date range.
Input ; 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 <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col></colgroup><tbody>
</tbody>

Output Need;

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	08-05-2016	09-05-2016	10-05-2016	11-05-2016	12-05-2016	13-05-2016	14-05-2016	15-05-2016	16-05-2016	17-05-2016	18-05-2016	19-05-2016	20-05-2016	21-05-2016	22-05-2016	23-05-2016	24-05-2016	25-05-2016	26-05-2016	27-05-2016	28-05-2016	29-05-2016	30-05-2016	31-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	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00	21,150.00
ABO1	KGW	F80	C535	23	ABO1KGWF80C53523
ABO1	KGW	F97	C540	23	ABO1KGWF97C54023

<colgroup><col><col><col><col><col><col><col span="31"></colgroup><tbody>
</tbody>

 

[ncpavan08]

Hi everyone,

Please find the incomplete Macro code which is written by friend.

Range("g3").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(g2,Input!G:I,3,0)"

Range("H3").Select
ActiveCell.FormulaR1C1 = "=IFERROR(VLOOKUP(h2,Input!G:<wbr>I,3,0),RC[-1])"