Hi all,

I'm a fairly novice Excel user and I'm trying to set-up a simple project scheduling workbook for my company.

I was hoping that one of you may know how I can do the following...

I want to set-up a macro that I can run that will:

Search column A on two separate worksheets (sheets 1 and 2)
If data is found on sheet 1 that matches data on sheet 2, do the following:
Return the data contained in a specified column corresponding to the particular row in which the match was made, onto the other sheet.
Here's the even trickier part... I want it returned in the form of a comment in a specified cell on sheet 1

Confused?

Here's an example --

Sheet 1 has a list of 3 people:
Column A (Name) - John, Frank, Sally
Column B (Eye Colour) - Green, Blue, Brown

Sheet 2 has a list of 4 people
Column A (Name) - Mark, Paul, Megan, Sally
Column B (irrelevant data) - blah, blah, blah, blah
Column C (irrelevant data) - blah, blah, blah, blah


I want to run a macro that will search column A on both sheets. When it matches "Sally", I want it to return "Eye colour - Brown" as a comment in cell C4 on sheet 2.

I obviously intend for this to run on a larger scale than what's listed in the example. Each sheet in my workbook has about 100 data sets which are constantly changing.

AM I CRAZY?