Most valuable professional
  • Hot Topics

Excel Excel first timer Macro user

Hi, this is my first time having the need of a macro and its 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 its 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

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel