Delete entire row based on value using VBA

I run a Macro to get data from one work book and getting the output in another work book. However the last row is unnecessary in the output file. May I know if there is any VBA code available to remove that unnecessary row while running the macro automatically? Please refer to the image attached. That's the row I would like to delete. This data is received after running a Macro. I would like to add a code with that Macro so that this line will be deleted automatically. The Row number will change in each workbooks. So I would like to delete this row based on the value please. The values of Column E and Column R will be same for all workbooks for the final Row. Please help me remove it.