Add Rows between items

Add Rows.xls

please see new attached. in your previous macro it added one blank row between each item #.
attached is new spreadsheet with rows 2 & 3 actually having the same item #.
Macro needs to insert the blank rows between each change in value & add 10 blank rows instead of 1.

Thanks

See if this is what you want

Please Login or Register  to view this content.

that added 10 blank rows between all #'s again. didn't recognize that rows 2 & 3 were same item # & don't need blank rows between them, same with rows 6 & 7

Then

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

RSA,
try this one.

Please Login or Register  to view this content.

Don't understand what you are saying...

jomili- this worked great to an extent. It added my desired # of rows between each change it item #. It did however add blank rows just underneath the header row which is in row 1. Don't need blank rows between heard and first item #. Item #'s will always be in column B so can we get rid of the message box asking for which row we want to analyze?

We could get rid of the message box, but that would force you to preselect the range of rows to add the extra rows in. Otherwise, without a defined area, the macro will work on the entire sheet, so every row, which will slow it down considerably.

If you don't want rows added after header, select from Row2 down to the last row for which you want to insert rows.

I tried selecting from row 2 down to last row & it still added rows after the header

Sorry, you're right. The selection thing is intended to determine the last row you want to do blank rows in, not the first. Changed it in the code below (see line in red). Also hardcoded Column B (you'll have to change this if your structure ever changes)

Please Login or Register  to view this content.

It worked - AWESOME - Thanks