Can you post what you had recorded? I might be able to work with that...

Mark

"Dave" wrote in message
...
I have a spreadsheet of items and their sizes. Each item has 7 sizes. I
need
to add 6 rows under each item and copy the data from the from the first
row.
There are 150 items in the spreadsheet and I basically need to create a
macro
to copy each item 6 times right underneath the original item.

I'm not very familiar with macros. When I started trying this, I just kept
getting the macro to create the same row over and over.

Any help would be greatly appreciated.