Skip to main content

Hi, may I ask if anyone know how to find the next blank cell in Excel and delete the entire row that with this blank cell by Excel basic package? 
Also if anyone know how to get cell value from 3 different sheets(in 1 workbook) and set value to another sheet at the same time? 
Thank you!

Hi @fiona42811 

Use Excel Advance  package → Remove Blank rows command in the specified range or you can write custom VB script as well


Reply