lookup formula or a macro?
Hi
I have 2 sheets. There are one string like E1234 and one date on each sheets in one row...
E1234 11/11/2007
E5846 12/10/2007
The strings are the same in the two sheets in the same columns but they are in different rows related to the other sheet. My aim is: if one date has changed, the date would change on the other sheet also according to the string.
|