Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
how do I insert multiple rows in excel after every row of data | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |