title: Copying of data skipping blanks
body: <p>Good Day, can somebody please help me.  I have 2 spreadsheets, the second spreadsheet has got the copied cells exactly like the first one.  But my problem is that on the first spreadsheet I have blank rows as the invoices are being put in date order and not invoices on every day.  The second sheet I use for Vat purposes and want my selection there to be in list form in order to only print 1 page for bookkeeper.  Where I have invoices for eg. on 10th, 15th and 20th on first spreadsheet "what formula can I use for the 3 invoices to appear in the second spreadsheet eg. in row 1,2,3 one right underneath the other one.</p>
  
  <p>I have done VBA 20 years ago and came right with everything except this I can not figure out for the life of me.  Thanks in advance to anybody that can help me with this.</p>