View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SludgeQuake
 
Posts: n/a
Default Deleting Rows Automatically using a Text File List

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