Hello,
I am trying to solve the following problem:
1. I have a number of csv-files, each has 5 columns of data.
input1.csv
input2.csv
......
inputN.csv
2. I want to
- do one operation on 3rd column of each file (IMABS(col(C)),
- place result into 6th column (first free column in my case) and then
- copy this new column into first free column of another excel file Output.xlsx
pasting from the 2nd row in each column of Output.xlsx (as the 1st rows will have titles in them)
To summarise: I want 6th column of each input.csv file in SourceFolder copied into separate column of output.xlsx file
I should be ok with writing code for copying and pasting within one file, but what I don't know is how:
1) to open multiple files from a specific folder (Sourcefolder)
2) Copy and Paste data from one file into another file
Any help with this issue is greatly appreciated.
Thanks
I am trying to solve the following problem:
1. I have a number of csv-files, each has 5 columns of data.
input1.csv
input2.csv
......
inputN.csv
2. I want to
- do one operation on 3rd column of each file (IMABS(col(C)),
- place result into 6th column (first free column in my case) and then
- copy this new column into first free column of another excel file Output.xlsx
pasting from the 2nd row in each column of Output.xlsx (as the 1st rows will have titles in them)
To summarise: I want 6th column of each input.csv file in SourceFolder copied into separate column of output.xlsx file
I should be ok with writing code for copying and pasting within one file, but what I don't know is how:
1) to open multiple files from a specific folder (Sourcefolder)
2) Copy and Paste data from one file into another file
Any help with this issue is greatly appreciated.
Thanks