Macro To Create Duplicate Rows

[air044]

I have to import data and it reads as follows:
TAG cost qty Total
G13-1718 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 4 $600.00
G13-1718 $150.00 2 $300.00

$1200.00

What I need is that each row with more than 1 qty be duplicated and total dollars divided by the appropriate qty, Like the following:

G13-1718 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1599 $150.00 1 $150.00
G13-1718 $150.00 1 $150.00
G13-1718 $150.00 1 $150.00

$1200.00

see attached please

[p24leclerc]

try the following macro:

Please Login or Register  to view this content.

[air044]

try the following macro:

Please Login or Register  to view this content.

It works perfectly

[p24leclerc]

If column D is not a formula, you can use this modified macro:

Please Login or Register  to view this content.

[air044]

Perfect!! thanl you!