Ok, I hope this is a macro question, and I know this is an easy one for most. I have some Excel experience, but by your standards, probably little to none...

I have a workbook that has a part number in column A, and a number next to it in column B. I need whatever value is in column A copied and pasted in another worksheet the number of times listed in column B. So, it may look like this...

Mark 5
Brian 3
Jess 2

So, I want a new worksheet that looks like this....
Mark
Mark
Mark
Mark
Mark
Brian
Brian
Brian
Jess
Jess

Please help...>Thanks a million! I know how to record macro's, but not write them