CSV import to Excel based on specific data

[marreco]

Hi
I find this code in google

Please Login or Register  to view this content.

I need two things

1 When I use the above code the data is not correct as the CSV file. I need to fix this.

2 Is possible import to excel only data based (Código Cliente is equal to: 8160 and 144985 and 24334)?

Thank you!

[millz]

for 1. try adding decimal separator:

Please Login or Register  to view this content.

for 2. you can try doing a filter, and delete all rows where Código Cliente are not what you wanted. If you have no idea how do to this step, you can import the data first, then record a macro to do it, then try to combine the 2 codes together.

[marreco]

Hi millz, sorry, but doesn't work!

[millz]

It works when I save your "before" data into a CSV then re-import using the same macro.

Are you able to post how your original CSV file looks like? in .csv format of course

[marreco]

Look my original CSV file

[millz]

Ok, so you are using comma as the decimal separator. Try this now:

Please Login or Register  to view this content.

[marreco]

Thanks millz, very good.

2. you can try doing a filter, and delete all rows where Código Cliente are not what you wanted. If you have no idea how do to this step, you can import the data first, then record a macro to do it, then try to combine the 2 codes together.

Tha second doubt. is it possible?

[millz]

Try this now:

Please Login or Register  to view this content.

[marreco]

Hi.millz

that worked brilliantly, I really appreciate your help