satish.nl
05-11-2016, 03:59 AM
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
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