data from one column to produce data for next 3 columns

[sasoderl]

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???

 

[junebug]

Try this for the heck of it. Assuming your numbers from 36-100 are in column A, then in column B paste this formula:
=vlookup(offset($A$1:$A$100,0,0),DATA,2,FALSE)
in column C paste this formula:
=vlookup(offset($A$1:$A$100,0,0),DATA,3,FALSE)
in column D paste this formula:
=vlookup(offset($A$1:$A$100,0,0),DATA,4,FALSE)
Copy these formulas down the rows. You may have to adjust the row reference $A$1:$A$100 depending on how many rows of numbers you have in column A. Make the adjustment before you copy the formulas.