title: Excel loop copy paste until blank cell in column
body: <p>I'm trying to copy data in column B starting at cell B5 and paste into cell E2. Loop this until a blank cell in column B overwriting E2 every time. Any suggestions? </p>