Use field value to populate list on seperate worksheet

[skidz]

I have a list of names with a second column listing a desired quantity.

I.E. Bob Smith 1
Lisa Smith 5

I need to return a list of values showing "Lisa Smith" 5x and Bob Smith 1x

Bob Smith
Lisa Smith
Lisa Smith
Lisa Smith
Lisa Smith
Lisa Smith.

I used an IF function to subtract column b and use "Lisa" again if B1-b2>0. This works but it skips the next 4 entries in the list until it reaches 0. Doesn't matter how it's sorted in the final. I just need a list for a variable data print run having each name occur however many times are shown in column b.

[sweep]

Hi,

This code should do as you ask. Insert a new sheet named "New Sheet" and run.

You can change ranges and sheet names as required.

Please Login or Register  to view this content.

[skidz]

Hi,

This code should do as you ask. Insert a new sheet named "New Sheet" and run.

You can change ranges and sheet names as required.

Please Login or Register  to view this content.

That worked! Thank you. You just saved me a a ton of time!