Comparing a list to a Calendar worksheet.
Please help,
I have a list of approximately 250 items in the following form on sheet1:
Column A Column B
APLU4586535/APL 8/25/05
All items in column A worksheet 1 are unique.
I need a formula that will take each item in Column A worksheet 1 and see if
it appears in Worksheet 2. Worksheet 2 is set up as a calendar as follows:
Column A Column B Column C Column D
Column E
8/1/05 8/2/05 8/3/05 8/4/05
8/5/05
APLU4235458 HDMU4531258 APLS2254782 MLCU6541234 HDMU3254258
8/7/05 8/8/05 8/9/05 8/10/05
8/11/05
HDMU7894561 HDMU1234567 APLS4561234 HDMU7891234 HDMU6398521
There are several unique entries in each column of worksheet 2.
If the entry in column A worksheet 1 does not appear in worksheet 2, I need
the formula to enter the data from Column A worksheet 1 into the appropriate
cell in worksheet 2. That is, if Column A worksheet one is not found in
worksheet 2 it looks at column B worksheet 1 and matches to the date found in
worksheet 2 and enters the data under that date.
One other thing I need it to do:
Worksheet 2 is color coded. If column A worksheet 1 appears in worksheet 2
and the entry in worksheet 2 is green, I need it to highlight or delete the
entry from Column A worksheet 1.
Thank You,
Patrick
|