I have a training spreadsheet that has courses and names. We are importing
to a new training system and need to put new codes with the old course names.
There are about 11,000 lines and it is in Excel 2007. The first sheet has
all of the old information, person's name, date of training, and old course
number or name. The second sheet has the course info, old and new numbers.
Is there a macro that will start at the second line (headers on first line)
take the old course number from the first sheet, match it with the old number
on the second sheet, fill in the new number in a blank column on the first
sheet. then move to the next line and repeat until it is finished. I can use
paste special if there is a way to display the correct info from the second
sheet with an equation in each cell of the currently blank column.

Thanks in advanced for the help.
--
Tom