How to create a macro to sort a .csv

[Rensi]

This is my first post, I'm glad I found this forum.

I need to create a macro to sort a .csv into a readable format, like a report. The .csv contains data related to users and various stats attributed to each user. I want to be able to run a macro to generate a form with employee names and columns with each stat that I can conditional format as I need.

We have something like this already that was created a few years back by another employee that takes three .csv files and generates one easy to read report, but its fairly complex and we have yet to dissect it with any success. I will need to build this from the ground up.

I sense there is no easy answer to this, I was hoping someone could just point me in the right direction. I'm sure I can figure it out but I don't know where to begin looking.

Thanks,

Andre

[JBeaucaire]

If the CSV is in the same format each time, you can start by recording a macro yourself of you manually importing the file and setting the importation settings the way you need them during the import.

Once the data appears in your sheet the way you want, stop the recording macro and take a look at the code it generates. You learn a lot that way. That's a good place to start.

TOOLS > MACRO > Record a new macro

[Rensi]

Thanks Ill give that a try today.

[JBeaucaire]

Did it work out OK? I've done that before so I know it serve.

Be sure to EDIT your original post and mark the PREFIX box [SOLVED] if you're happy with your results.