How to remove blank rows and remove data after blank row

Help
, ,
1

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
2

Hi.

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”.

Thanks.
-Tera

3

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