Macro to insert lines and copy

[AdrianLeCoyte]

I would be grateful if someone out there could help me.

I have a whole load of data (part number, quantity, location and some other related data). I am going to print labels for all the parts being received.

My problem is that in order to do this, I have to view the quantity for each line, then insert the corresponding number of lines minus one, then copy the first line down to the insert lines.

A sample of the data would be:

QTY
MB241423 5 40.07 200.35 47230 87f 20% FMS
MB241429 2 4.13 8.26 40632 87f 20% SUSLK-12
MB257484 1 0.53 0.53 68422 87f 20% MWP

The result would look like:

QTY
MB241423 5 40.07 200.35 47230 87f 20% FMS
MB241423 5 40.07 200.35 47230 87f 20% FMS
MB241423 5 40.07 200.35 47230 87f 20% FMS
MB241423 5 40.07 200.35 47230 87f 20% FMS
MB241423 5 40.07 200.35 47230 87f 20% FMS
MB241429 2 4.13 8.26 40632 87f 20% SUSLK-12
MB241429 2 4.13 8.26 40632 87f 20% SUSLK-12
MB257484 1 0.53 0.53 68422 87f 20% MWP



I have 682 lines and a total quantity of 2227.

So this would take a long time to do manually...

This forum has been great to me in the past. I hope that you can help me again.


Thanks,


Adrian

[mrice]

Try this macro

Please Login or Register  to view this content.

[AdrianLeCoyte]

This works great.
Thanks Very Much.


Adrian