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.

enter image description here

Link to sheets below:

  • pls share a copy of your sheet – user0 Jul 9 at 22:06
  • I have shared the link to my sheets – Peter Hardwick Jul 10 at 22:47
  • sheet is private – user0 Jul 10 at 22:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.