Matching Dictionary Terms with Definitions

Hi,

I have created a dictionary with technical terminology. It is in excel format with about 10,000 entries. The format of my dictionary ("Sheet1") is in three columns:

<vocabulary term> <pronunciation> <definition>


Now, I want to create vocabulary lists using my dictionary. The newly typed up vocabulary list (which only has the term, but not pronunciation or definition), will be copy and pasted into "Sheet2".

The "Sheet2" typed up vocabulary list is in the format:

<vocabulary term 1>
<vocabulary term 2>
etc...


I want to run a macro or script to dictionary terms (including pronunciation and definition) from "Sheet1" and put them into my vocabulary list "Sheet2".


The desired output list in "Sheet2" is:

<vocabulary term 1> <pronunciation> <definition>
<vocabulary term 2> <pronunciation> <definition>
<vocabulary term 3> <pronunciation> <definition>
etc...


I would be grateful if someone could help me write a macro to do this?

Sorry, I am pretty much a complete newbie to this and would greatly appreciate any help that can be provided.

Thank you!