title: Macro to compare two columns and insert one line if missing
body: <p>here is what I'm trying to achieve, in order to get rid of a lot of manual works. I basically have two lists, each made of two columns (we'll call it colA, colB, codD and colE). The first list (A+B) is normally bigger than the second (D+E), so my goal is to automate the process of spotting missing entries, insert a line when found one (actually, scroll down only the corresponding two cells of colD and colE) and then loop to the end of the left list.
  Normally, I manually do this by put an IF comparing the cells in colA and colD, if different -> add a line a scroll down, then loop.</p>
  
  <p>How can this be automate with a VBA Macro? I save you from my junk codes I tried so far, I think it's a super-easy question for you out there... :)</p>
  
  <p>Thanks in advance
  A.</p>