I have a text file with a list of filenames (all .jpg) that I want to
delete from my Excel sheet (the entire row, not just the filename).

Without looking up each one of the files (listed in the text file) and
deleting the row manually, I would like to eliminate the rows
containing this filename.

I am sure there's a way to automate this! I just don't know how, and I
do not know Excel as well as some people here. I don't know macros or
anything. I just know Excel better than anyone at my office (which
doesn't say much I guess).

~ Arielle

SludgeQuake Wrote:
Sorry, I misread your problem... but now that I've read a bit more
closely, I
realize I don't quite understand. Do you import the text file to Excel
and
then delete any row with one specified file name? or are you creating a
new
text file with any file name deleted that is contained in a range
contained
in a column with a label filename.

"mirdonamy" wrote:


I have a text file list of .jpg files that I want to delete (rows)
from
Excel. The list has 800+ items in it. Deleting these rows one at a
time in Excel (after doing a "find") is terribly time consuming.
Does
anyone know how to make Excel read my text file and delete the rows
with that filename in it (automatically). The filename (listed in
the
text file) is in a column (in my excel sheet) called "filename".

Any help would be most appreciated!!! Seriously! I may have to
spend
hours on this otherwise!

Thank you,
Arielle


--
mirdonamy

------------------------------------------------------------------------
mirdonamy's Profile:
http://www.excelforum.com/member.php...o&userid=30348
View this thread:
http://www.excelforum.com/showthread...hreadid=500059




--
mirdonamy
------------------------------------------------------------------------
mirdonamy's Profile: http://www.excelforum.com/member.php...o&userid=30348
View this thread: http://www.excelforum.com/showthread...hreadid=500059