How to combine two Excel sheets by removing blank rows automatically ?

Why don't you use functions like Vlookup? And rather than deleting information from sheet, just hide the row/column/sheet. Google for further information on Excel functions or use the websites mentioned in the earlier response. Welcome to the amazing world of automated accounting.