title: Excel VBA Macros to copy and paste cell value to certain cells based on text in column
body: <p>I am attempting to copy and paste text values to a certain amount of cells in excel based on a text comparison. </p>
  
  <p>Please see below for explanation:</p>
  
  <p>I have 2 column A(blank) and B(with values)</p>
  
  <p><img src="https://i.stack.imgur.com/WqQvm.jpg" alt="enter image description here"></p>
  
  <p>After the macros, this will be the end results:</p>
  
  <p><img src="https://i.stack.imgur.com/CKxkl.jpg" alt="enter image description here"></p>
  
  <p>It is basically taking the bottom cell after it detect the fruits column and pasting the cell value into row A. Note that after it reaches the next cell fruits it take the next (bottom) cell value. F123,F124 etc..</p>
  
  <p>Can someone please provide me with the excel vba codes to do? Thanks.</p>