View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tomi12619 tomi12619 is offline
external usenet poster
 
Posts: 6
Default 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.