copy filtered data into different worksheet

[satish.nl]

Hi, im new to vb scripting
my requirement is i have to import text file into excel which looks like this


Au
1
63
4
1855
565


Ad
4
10
6
1633
88


Ad
10
100
78
1765
1555


Au
23
215
55
1558
6655


Au
255
225
145
258
654




I need to filter 1st ,3rd and 4th columns

Problems which im facing is


1)Always Au(1st row of data) is not written on same row in the Excel when import the text file.
for example if i import abc.txt into excel it will appear on 49th row
for xyz.txt it may appear in 40th row,

there is no fixed header

2) for 3rd and 4th columns values are always not same(different for different text files) , i need to select largest value for both columns in filter


3) i need to copy filtered data(visible data) into another sheet.

Please provide me your valuable suggestion and inputs

Thanks in advance,
Satish