View Single Post
  #1   Report Post  
bob
 
Posts: n/a
Default Insert rows based on specific value

Worksheet is 20 columns x 50 rows. Column C is populated with the string
"Atl." from rows 2-15, with "Bos." in rows 16-33, and with "Cha." in rows
34-46.

I want to automatically insert 10 blank rows, beginning with the first cell
in Column C that isn't populated with "Atl." (row 16 in this example). Then I
want to insert 6 blank rows, beginning with the first cell in Column C that
isn't populated with "Bos."

I want to account for that fact that the number of "Atl." rows will be
variable; they always begin with row 2 but may not always end with row 15.
And that the "Bos." rows will always begin with row 25 (due to insertion of
blank rows) but may not end with row 42.