Insert Multiple Copies Based on Cell Values

**bradwats** · 10-19-2007, 08:14 PM

Hi People

I have a customer who regularly provides me with a list of items, with a column to the right, indicating quantity of each item required. I am attempting to find a way to have the left-hand column contain a full list of the items - i.e. where there is a quantity of n in the right-hand column, the left-hand column should display the item n times.

Would be grateful for any hints, as I have tried everything I can think of, to no avail.

Many thanks
bradwats

**starguy** · 10-20-2007, 12:49 AM

Can you provide example of the data. (you can attach sample file in zip formate)

**bradwats** · 10-20-2007, 01:17 AM

Hi starguy

My apologies... please see attached file

bradwats

**starguy** · 10-20-2007, 01:27 AM

Originally Posted by bradwats

Hi starguy

My apologies... please see attached file

bradwats

Following thread may be helpful to you.

http://www.excelforum.com/showthread.php?t=592517

**bradwats** · 10-20-2007, 01:39 AM

Many, many thanks, starguy... the macro in "splitting 1" is more suitable for my needs - this will save so much time...

Thanks again for your assistance

bradwats

**starguy** · 10-20-2007, 01:45 AM

Originally Posted by bradwats

Many, many thanks, starguy... the macro in "splitting 1" is more suitable for my needs - this will save so much time...

Thanks again for your assistance

bradwats

You're welcome and thank you for the feedback.