Hello everybody,
I am a PhD Student who manage csv data and I would like to import such data in excel and organize them in a worksheet. I have already written something in VBA but not really want I wanna do. I am searching for everyone who want help me or collaborate to broad the macro to other simple arithmetic functions. I could insert the name in the scentific pubblication if somebody want to take part to this simple macro. If you are interested please contact me at alberto.steffani@ocbc.uni-freburg.de.
What I would like to do is this:
I have 100 *.csv files, each on contains 2 columns. The first columns is the same for each file and the second changes and I am interested to have such columns in the same Worksheet. What it follows is simple the sum of each columns extracted and later a linear extrapolation of the data. What I done until no is that:
This program permit to choose the *.csv files in one shot and it place each set of 2 columns in different columns than the second extract the second columns of each set and place all of them in one single new worksheet. The problem is that it places each column in the same columns and I wanna have just the opposite: each column in different columns.
I hope that somebody will help me. I thank you in advance.
Sincerely,
Alberto Steffani
LinkBack URL
About LinkBacks
Import and organize csv file automatically
Register To Reply
Bookmarks