I am trying to write a macro OR something that will allow me to take the data entries in one column and produce the data that belongs in the next three columns.
The idea is that I have one column of numbers that range from 36 to 103. Each number is a "code" that has information that I want to appear in the spreadsheet but don't want to type it all up every time. With each of these numbers, I need to insert into the next 3 columns a two-letter code, a sentence, and a price. The info that belongs to the "code number" will never change. I'd like to automate this. How???