I am trying to write a macro in vba. I have sheet A with the following columns :
Ref Id name Company Date1 x b Date2
a 4 MMM fahdfj 12/31/12 n y 12/31/12
I have sheet B with the following columns :
ID Name Date1 date 2
4 MMM 12/31/12 12/31/12
5 ABT 12/31/12 12/31/12.
What I want to do is Look at sheet A and read in each ID. Check this Id in Sheet B and check the date in the Date 2 column. If the Date2 in Sheet A is less than or equal to the Date 2 column in Sheet B then I want to change the Value in the Ref column of Sheet A to be "D".
Can anybody help me with this?
Kind Regards
Bookmarks