How to have excell continuously check cells and automatically delete rows

[kenviluser]

Ok so I'm setting up an excel template for use in my office. Basically the template will look something like the image below. There will be two separate charts, one above the other, and cells A2-A10 will have a list of categories to choose from. I want to set the sheet up so that if the 'End' option is selected from the list, that row and the rows below it through A10 will automatically be deleted. For example, if the user selects the 'End' option in A5, excel will automatically delete rows 5-10 and shift the remaining rows up. I've found ways to delete rows based on cell value using a VBA module, but they require the user to manually run the module after the values have been entered. I could also tell the people in the office to simply manually delete the rows that they end up not using, but honestly, most of the people in my office are not computer literate and I want this thing to be as user friendly as possible.