Hello everybody, i'm new here and i'm aiming to learn new stuff
So far, i've come with a problem i hope you can help me with, it would be great.
I have an excel file with a couple of columns with contacts. I need to split this contacts into sheets depending on the language they speak. I created a sheet for each language and i want to move, for example, like this.
If Column A (languages) has cells with the value "English", then move the entire row to Sheet2 which is named English
If Column A (languages) has cells with the value "German", then move the entire row to Sheet3 which is named German
Each row has names, phone number, email, etc.
This way i want to create a sheet with the contacts of each speaking language.
I've tried some home made VBA but i failed miserably. I could use any help.. Thank you very much!
So far, i've come with a problem i hope you can help me with, it would be great.
I have an excel file with a couple of columns with contacts. I need to split this contacts into sheets depending on the language they speak. I created a sheet for each language and i want to move, for example, like this.
If Column A (languages) has cells with the value "English", then move the entire row to Sheet2 which is named English
If Column A (languages) has cells with the value "German", then move the entire row to Sheet3 which is named German
Each row has names, phone number, email, etc.
This way i want to create a sheet with the contacts of each speaking language.
I've tried some home made VBA but i failed miserably. I could use any help.. Thank you very much!