Text File Import and Filter

[danprhayes]

Hi

I have a comma seperated value text file and want to import to Excel (easy) but I want each row of the text file to be inserted into a specific row of the spreadsheet based on the first value in each row of the text file.

Why I need this (for info)...

The text file is produced from web form submissions and so rows differ month on month (different people submitting at different times).

My first worksheet contains the imported text file and subsequent worksheets are linked to each row of the first.

Get it?

Is this possible?

thanks