Macro to duplicate rows based on cell value

Hi All, I need a macro that will duplicate rows based on the value in cell A.

Here is my starting data:
Qty Item# Description
2 89825 Sham Qn Sam
2 85415 Sham Qn Biscotti
4 94888 Sham Qn Baroque

And here's the needed result:
Qty Item# Description
2 89825 Sham Qn Sam
2 89825 Sham Qn Sam
2 85415 Sham Qn Biscotti
2 85415 Sham Qn Biscotti
4 94888 Sham Qn Baroque
4 94888 Sham Qn Baroque
4 94888 Sham Qn Baroque
4 94888 Sham Qn Baroque

Any help would be greatly appreciated!

Thanks

Hi KBEZ,
try so

Please Login or Register  to view this content.

Give this a try?

Please Login or Register  to view this content.