Blank rows read as errors on transferring from excel to sage accounts

My workbook produces up to 30 invoices

It includes a summary sheet that prepares the data for input into Sage Accounts. As there are not always 30 invoices some of the lines on the summary are necessarily blank. I have a macro that deletes these blank lines but leaves a "frame" around the entire 30 lines so that Sage thinks there is data in them & issues error reports to the effect of invalid data on the blank lines.

I can get round this manually by deleting the offending lines, highlighting the valid lines & saving the file again before entering it into Sage.

But I want junior staff, with little Excel competence to handle this.

I there a VBA solution to eliminate the blank lines so that only the lines with "real" data are read by Sage?

With thanks

Dave