import csv into an excel

[kerm007]

hello
soem one in my office ask me to find a solution for them
they have a CSV file and they want to import it into excel but the excel do some kind of calculation etc...
is it something feasible ?
they want to avoid doing the same step over and over again
Thanks

 

[6StringJazzer]

To import a .csv file into Excel you simply open the file in Excel.

excel do some kind of calculation etc...

This is so vague that it is not possible to answer. It sounds like you need a macro. But there is no way to give you VBA unless you give very specific information about what you want to happen.

 

[kerm007]

i will gather the info and get back to you
regards

 

[kerm007]

the csv contain this data

what they want is a template to get this data imported but the Colum b they rounded the time with this formula : =A5/60000

not sure what goes into the other Colum yet

 

[6StringJazzer]

Colum b they rounded the time with this formula

Your formula in column B refers to A5 but column A is blank except of the header "Agilent CPX". It is not possible to tell what data from the original csv file is mapped to what column in the second picture.

 

[kerm007]

hello the data from picture 1 colum A goes to colum A on the second pictures starting A5
Thanks

 

[kerm007]

Hello all
any other advices ?
Thanks

 

[kerm007]

hello anyone have other idea im trying to find a way to give them less job to modify the excel
Thanks