looping in vba for excel
What I'm looking to do is write to a
file the specific rows I sorted on. One record per line.
I know, it sounds re-dundant, but it's part of a larger picture.
fyi. the column value for the records I need write is x. if there's
an x in that comlumn for a record, write the record to a text file.
Now, since it's been over a decade since I last coded, I can't figure
out to start with what kind of loop to do. For, while, etc. And how I
read from the Excel spreadsheet.
Thanks in advance.
-Michael
Psuedo code:
For each row with column "T"="x" Do
Write row to c:\sorted_data.txt
End For
|