Shift Excel Row Based on Cell Value

March 23, 2009 at 12:56:32
Specs: Windows XP
Hi

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!


See More: Shift Excel Row Based on Cell Value

Report •


#1
March 23, 2009 at 15:59:42
You should probably post this in the Office Forum.

Report •
Related Solutions


Ask Question