|Subject:||Copy data from sheet 1 to sheet 2|
|Date:||Tue, 15 Jul 2008|
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.