Excel: Excel first timer Macro user


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


This question generated 30 answers. To proceed to the answers, click here.

This thread is current as of February 23, 2015.


For more resources for Microsoft Excel