Hi,
I have serveral very large spread sheets, and I need to insert a blank row
when the data changes in a column for example

\mnt\snd\pvcs\ncs\abctv\archives\oracle_reports\or tv0410.rdv
N:\admin\oracle_dba\archives\bin\usr\prodaccess.sh-arc
N:\admin\oracle_dba\archives\bin\usr\prodaccess.sh-arc
N:\admin\oracle_dba\archives\bin\usr\prodaccess_ch eck.sh-arc
N:\admin\oracle_dba\archives\bin\usr\prodaccess_ch eck.sh-arc
N:\admin\oracle_dba\archives\PVCS\config\ncs_maste r.cfg-arc
N:\admin\oracle_dba\archives\PVCS\config\ncs_maste r.cfg-arc

I would want to insert a blank row after
\mnt\snd\pvcs\ncs\abctv\archives\oracle_reports\or tv0410.rdv and
N:\admin\oracle_dba\archives\bin\usr\prodaccess.sh-arc

I tried uisng the a2=a3 formula, then sort for false and select only
visible cells, but it was a little funky
Is there a macro or something I could use to do this? I am using Excel 2003
Cyndi