execl.PNG

The goal is to auto sum the data based on water and air. So all water will be together and all air will be together. I am trying to work a way to auto sort as I continue to enter more data. I know Ill be able to simple click the sort & filter in excel but someone else might be entering data and wont click that feature. The data is linked to graphs however I can't figure out how to automatically update the (air) and (water) graphs if the data isnt sorted. I was thinking to have the data auto transfered to different tabs based off the same characteristic of water or air, so it can then be updated in the graph. I'm not sure if this makes sense but I hope someone will be able to understand and help.

Thank you!!