How to remove blank rows and remove data after blank row

i have attached excel sheet. i want to delete all rows after blank space.
and my second doubt is that i want to Remove rows with “00” in “File #” column or “0.00” in “Federal tax” column. Move these records to a new file and insert the header record as the first row. Save the file Invoicly_data.xlsx (10.0 KB)

1 Like


I think there are several ways to delete all rows after a blank, but use “For Each Row” to check if the row is blank, and if it is blank, use “Break”.

The second question is solved by “FilterDataTable”.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.