View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mikri mikri is offline
external usenet poster
 
Posts: 2
Default Sort and/or merge to worksheets.

Hi,
I am new to Excel, and need some help in sorting and/or merging two
worksheets. The scenario is:

I have two worksheets (let's say "T1" and "T2"), each contain two columns of
data.
The worksheet "T1" is a complete list of tag's (column A) and it's
describing text (column B).
The worksheet "T2" is arranged in the same way, but it doesn't contain the
complete list of tags (just a few hundred of them) the describing text on the
other hand is different. My goal is to replace the describing text for each
tag (for each tag that also exist in "T2") in "T1" with the text from the
same tag in "T2".

Is there an easy way to do this?

regards,

mikri.