need help in creating macro

ncpavan08

New Member
Joined
Nov 28, 2016
Messages
2
Hi everyone,

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

[/FONT]
Note:
1There will be a possibility of "additions" or "deletion" in collums in between "A" to "E".
2And 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 ;


ABCDECONCATENATEValid FromValid toAmount
ABO1KGWF97C53423ABO1KGWF97C5342302-03-201605-05-2016 20,400.00
ABO1KGWF97C53423ABO1KGWF97C5342306-05-201631-12-2016 21,150.00
ABO1KGWF80C53523ABO1KGWF80C5352302-03-201601-05-2016 20,325.00
ABO1KGWF80C53523ABO1KGWF80C5352302-05-201631-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;

ABCDECONCATENATE01-05-201602-05-201603-05-201604-05-201605-05-201606-05-201607-05-201608-05-201609-05-201610-05-201611-05-201612-05-201613-05-201614-05-201615-05-201616-05-201617-05-201618-05-201619-05-201620-05-201621-05-201622-05-201623-05-201624-05-201625-05-201626-05-201627-05-201628-05-201629-05-201630-05-201631-05-2016
ABO1KGWF97C53423ABO1KGWF97C53423 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
ABO1KGWF80C53523ABO1KGWF80C53523
ABO1KGWF97C54023ABO1KGWF97C54023

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

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

ncpavan08

New Member
Joined
Nov 28, 2016
Messages
2
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])"

 

Watch MrExcel Video

Forum statistics

Threads
1,133,524
Messages
5,659,315
Members
418,496
Latest member
WHYCHumphrey

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top