Help with export data to text file.

I have a text file generated with the following code that is pipe dilimited. What I am trying to accomplish is:
1. remove the first three rows of the excel file from the text file
2. in Column A (represented as Cells (N, 1) I need to skip if Alpha
3. In Column A end if Blank

Here is what I have so far. I am reciving Compile error " Next without For"

Please Login or Register  to view this content.

Thanks tiger, This works perfect!! Only one thing. On the end there are 7 rows (in the excel file these have value in them) that reflect pipes with nothing between them.Please see attached.

Thanks
Leslye

I cannot, unfortunatly, It has company sensitive information. I can give you a more detailed description of what my goal is and what columns from the excel sheet are affected. The amount of rows however are variable.

The goal is to have Columns A, C, E, L, P & S exported to a delimited text file. This text file will the be queried by SQL to go into other databases and reports.

The first 3 rows are headers therefore are information that is not needed in the text file.

Column A is tricky. an example of the data in listed form would be
INDA
4638
4672
4620
4845
4856
MSTA
4665
4664
4808
4853
PSTA
4643
7643
4647
4801
7801
4505
4807
4842

the only value I need to pull is the numeric value.

At the end of the listed numbers/ letters in Column A there is an empty row followed by 4 cells that have report data in them:
Number of sites with BIE:
# of sites closed w/errors:
# sites G/L file resent:
# of sites closed late:

This data needs to be left off of the exported data. The only thing needed on the .txt file from Column A are the numbers starting at row 5 and ending at the first empty row. The data in the other columns are only reported based on the cells that have a number in them from column A.

I hope this helps clarify. Please let me know if you can help in any way.

Thanks again,
Leslye