| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Rows Automatically using a Text File List
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling Text from Another File | Excel Worksheet Functions | |||
| how can i convert text file to excel file ? | New Users to Excel | |||
| Importing text file to excel | Excel Discussion (Misc queries) | |||
| Importing a text file into Excel with too many rows? | Excel Discussion (Misc queries) | |||
| how i make a pgm in excel for copying all the rows to a new file . | Excel Discussion (Misc queries) | |||
Threaded Mode
