C
czywrg
There are two sheets. I would like to be able to run a macro on Sheet
that
looks up the row value from column F in sheet1 after matching the dat
in each row with columns A,B,C,D from sheet2. If it does not have
match, it would put "new" in column F.
Sheet1 looks like this and is a dynamic range named "data":
2005i Line1 MID 5/20/06 6/20/06 Joe
2005j Line2 TMP 5/20/06 7/1/06 Mike
2005j Line2 TMP 7/01/06 8/1/06 Fred
Sheet2 looks like this and is a dyanmic range named "data":
2005i Line1 MID 5/20/06 6/20/06
2005j Line2 TMP 5/20/06 7/1/06
2005j Line2 TMP 7/01/06 8/1/06
2006n Line3 PTY 9/17/06 9/25/06
Data would look like this after macro:
2005i Line1 MID 5/20/06 6/20/06 Joe
2005j Line2 TMP 5/20/06 7/1/06 Mike
2005j Line2 TMP 7/01/06 8/1/06 Fred
2006n Line3 PTY 9/17/06 9/25/06 NEW
Any suggestions will be appreciated
that
looks up the row value from column F in sheet1 after matching the dat
in each row with columns A,B,C,D from sheet2. If it does not have
match, it would put "new" in column F.
Sheet1 looks like this and is a dynamic range named "data":
2005i Line1 MID 5/20/06 6/20/06 Joe
2005j Line2 TMP 5/20/06 7/1/06 Mike
2005j Line2 TMP 7/01/06 8/1/06 Fred
Sheet2 looks like this and is a dyanmic range named "data":
2005i Line1 MID 5/20/06 6/20/06
2005j Line2 TMP 5/20/06 7/1/06
2005j Line2 TMP 7/01/06 8/1/06
2006n Line3 PTY 9/17/06 9/25/06
Data would look like this after macro:
2005i Line1 MID 5/20/06 6/20/06 Joe
2005j Line2 TMP 5/20/06 7/1/06 Mike
2005j Line2 TMP 7/01/06 8/1/06 Fred
2006n Line3 PTY 9/17/06 9/25/06 NEW
Any suggestions will be appreciated