You can do that by sorting a helper column.
In a adjoining blank column, auto fill it with numbers from 1 to 200.
Directly below the new data, autofill another 200 rows with numbers from
1.1 to 200.1. (just enter 1.1 in the first cell and 2.1 in the next cell and fill down)
Sort by the new column, clear the new column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Stephanie"
wrote in message
I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...