new to excel
Posted by Robin on September 13, 2001 7:19 AM
Hi MrExcel,
How can I loop through each row in an excel spreadsheet, and if a value exists in a particular column for excel to write that entire row out to a text file.
What do you think? thanks,
Robin
Posted by Mark W. on September 13, 2001 7:44 AM
No need to "loop" at all. Just apply an AutoFilter
for the value in question and then save file as
Formatted Text (Space delimited) (*.prn).
