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
Bookmarks