VBA: Auto-fill cells based on user defined values and quantity

Hello,

I'm trying to figure out a way using VBA where a user can specify values in 2 adjacent cells with a quantity in a 3rd cell, hit a button and have it insert the values entered a number of times equal to the quantity specified.

Sample Input:

Product	Price	QTY
Dog Socks	$2.95	4
Cat Mittens	$1.99	4

Sample Output:

Product	Price
Dog Socks	$2.95
Dog Socks	$2.95
Dog Socks	$2.95
Dog Socks	$2.95
Cat Mittens	$1.99
Cat Mittens	$1.99
Cat Mittens	$1.99
Cat Mittens	$1.99

The actual product list has 50+ products and the prices can vary so using formulas isn't ideal. There can also be up to 30 different types of product per order. I figure the best approach is using VBA and having the output values specified by the user, then executing it based on the # entered into the quantity, and outputting the values into the "next empty cell" on the output sheet.

Sample workbook attached.

Originally Posted by PCI

"only paste as values and not carry over the formatting?"
The code sent, only copies values ...just try it !

The reply you're quoting was directed at Mumps1, not you, since his initial code didn't paste as values.

I've tried yours and it works too. Thank you both!