title: VBA - Copy and Paste in next empty row on starting in Column B
body: <p>I am trying to have it copy from Data!A2:Z2 and paste in the 1st empty row on another sheet. However, column A has a formula and I'm looking for the first row where there is an empty cell in B to insert the data. So, if I have data through row 25, I would want it to copy the data and paste starting in cell B26. Of course the next time it runs it would paste in B27. Any help would be appreciated!</p>