From: crumismydaddy@yahoo.com   
      
    I'm using VBA for Excel and would like to do the following:   
      
   1) in sheet1, search for a value which is given in a specific cell location   
   on sheet2.   
      
   2) when i find that value in sheet1, i want to insert in the cell   
   immediately to the right of the active cell a formula which includes a   
   reference to a fixed cell location from sheet2   
      
   3) then i want to do the same search again in sheet1, this time using the   
   cell immediately below the cell in sheet2 used in the first search.   
      
   4) i want to continue this pattern until the cell on sheet2 below the one   
   used for the previous search is empty.   
      
   Thanks in advance for any help.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)