Hi, this is my first time having the need of a macro and it´s a bit overwhelming.
i started a new work and lets just say that no on here is very sharp when it comes to pc or what you can do with it most of the times.
so i get a list of car Models and types of the model in a txt doc witch most of the time is very long 100+ sometimes 10+ or 1000+. but it´s given to me in a very bad form and takes quite some time to do manual ea time..
and any one here help me with making a macro?
here is a very short example, of what i get to work with, and what i need to end up with
Model: Type
405: 101 103 121 123 201 221
900: 911 912 913 917 918 919 922 934 936 937 938
list goes one feels like its endless..
i need it to be made to
type Model
405 101
405 102
405 121
405 123
405 201
405 221
900 911
900 912
900 913
900 917
900 918
900 919
900 922
900 934
900 936
900 937
900 938
i started a new work and lets just say that no on here is very sharp when it comes to pc or what you can do with it most of the times.
so i get a list of car Models and types of the model in a txt doc witch most of the time is very long 100+ sometimes 10+ or 1000+. but it´s given to me in a very bad form and takes quite some time to do manual ea time..
and any one here help me with making a macro?
here is a very short example, of what i get to work with, and what i need to end up with
Model: Type
405: 101 103 121 123 201 221
900: 911 912 913 917 918 919 922 934 936 937 938
list goes one feels like its endless..
i need it to be made to
type Model
405 101
405 102
405 121
405 123
405 201
405 221
900 911
900 912
900 913
900 917
900 918
900 919
900 922
900 934
900 936
900 937
900 938
Last edited: