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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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])"

 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,521
Messages
5,854,198
Members
431,626
Latest member
Willway22

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