MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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,

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).