Copy data from sheet 1 to sheet 2

Giganews Newsgroups
Subject: Copy data from sheet 1 to sheet 2
Posted by:  netrange‚Ķ
Date: Tue, 15 Jul 2008

Hi All,

I need your assistance. I have a spreadsheet with two sheets, Sheet 1
and Sheet 2. Both of the sheets have a FileNumber (Column A) and Name
(Column B). I would like to copy the Name (Column B) from Sheet 2 to
Sheet 1 that matches the FileNumber in sheet 1. Please keep in mind
that some FileNumber (Column A) from sheet 1does not exist in sheet 2.

I would also like to insert a comment in Name (Column A) in sheet 1 if
the FileNumber does not exist in Sheet 2.

Thanks in Advance.