G
Guest
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.
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.