Thank you for your help!

What if I wanted to insert a row in Sheet1 AFTER the first occurrance
of NewYork?


Sheet1:

Total Breakdown by City

NEW YORK
NEWYORK 12 40 93 83 00 29 48
NEWYORK 20 89 85 01 92 30 93

BOSTON
BOSTON 20 102 94 29 10 48 29
BOSTON 50 152 54 39 15 43 59

etc.

Thanks!