*Hi guys, any help on this one would be great*.

I've got a problem that's causing me a headache. i have a document with
1 column and 4000 rows (its an export from active directory).

I need to do a search cell by cell (so A1 - A4000) for any cells that
contain the text "changeType". When a cell is found, i need excel to
insert a new row above the current cell and insert the text "modify"
into the new row (in the first column).

eg.

x
x
x
changeType
x
x

Becomes:

x
x
x
Modify
ChangeType
x
x

I dont use excel much so i'm pretty novice.

Thanks for any help you can offer

Andy


--
quinla01
------------------------------------------------------------------------
quinla01's Profile: http://www.excelforum.com/member.php...o&userid=31583
View this thread: http://www.excelforum.com/showthread...hreadid=512741