How can i remove the blank rows and the dotted lines from this excel file?

please help?
closing_stock_report_barcode celio VENKATESHWARA.xls (142 KB)

Use a for each row and if statement.

if text in current row first column = nothing or contains “----” remove the row

1 Like

Getting Read Range: Unable to construct record instance this issue while reading the file…how can i solve this?

xls file seems corrupted in some way. maybe save it with a different name error free

Column Value is repeated 2 times so how can i read it?

Thank you so much i have solved this issue

Thanks a ton!!!

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