I have a sheet (Sheet7), that imports data from another sheet (Sheet5) when a value is selected. The data is updated upon submission. The problem I have is if the cell value is not selected I get blank cells, or cells with zeros in, in-between the other data. I want to sort the data in the same order, but without the blank cells.
I have used a filter and it sorted it how I wanted, but it wouldn't automatically update. I included an image of the sheet, showing the data imported in columns A and B, with an example of how I want the data to be sorted in columns E and F.