I have an excel spreadsheet with two columns
of data. The first column is all descriptors. The
second column is data that pertains to the
descriptors in the first column.
I need a simple VBS script which will read
through the document and if a cell in column A
contains the text "file name:" (exactly that with
the ":" if possible), then a row is inserted
ABOVE the row with the text "file name:", thus
shifting all other data down one row.
The reason it has to be exactly "file name:" is
because other rows contain "file name (with
full path)". Not sure if it's an issue at all.
Thanks for the help!