P
PedroPeso
Hi,
I want to build a macro that imports all the txt files that are placed
in a specified directory. The text files are all the same, importing
from colomn 6 and onwards. The data from the files must be placed under
eachother.
how to do it?
problem#2:I want to calculate with the data from the text files, how do
i make excel arrange all the data that relates to a specific value.
example:
name points
Fred (textfile#1) 12
Ralf (textfile#1) 14
Guv (textfile#1) 11
Fred (textfile#2) 24
Ralf (textfile#2) 24
Guv (textfile#2) 88
Fred (textfile#3) 27
Ralf (textfile#3) 14
Guv (textfile#3) 19
I want excel to show this data as:
Fred 1 12
Fred 2 24
Fred 3 27
Fred total: 63
Fred average: 21
the same for Ralf en Guv....
any suggestions?
Thanks in advance!
I want to build a macro that imports all the txt files that are placed
in a specified directory. The text files are all the same, importing
from colomn 6 and onwards. The data from the files must be placed under
eachother.
how to do it?
problem#2:I want to calculate with the data from the text files, how do
i make excel arrange all the data that relates to a specific value.
example:
name points
Fred (textfile#1) 12
Ralf (textfile#1) 14
Guv (textfile#1) 11
Fred (textfile#2) 24
Ralf (textfile#2) 24
Guv (textfile#2) 88
Fred (textfile#3) 27
Ralf (textfile#3) 14
Guv (textfile#3) 19
I want excel to show this data as:
Fred 1 12
Fred 2 24
Fred 3 27
Fred total: 63
Fred average: 21
the same for Ralf en Guv....
any suggestions?
Thanks in advance!