I am looking at a list of bus routes (where some routes are deleted and some are added semi-frequently). I am stuck on figuring out how to have Excel delete or add specific rows in all worksheets automatically when I delete a bus route in the first worksheet. This would save so much time and allow me to modify the sheet much easier.

Here is the document: RPI_Sheet_Test.xls
Say for example I wanted to delete Bus Line #2.

I'd like there to be a way I can just delete the #2 (cell A6 on the DO Brdgs. Pass. Miles wkst) and run the macro so that all other rows corresponding to Bus Line 2 will be removed from the workbook.

Additionally, it would be nice to have it where if I need to add a Bus Line (say I wanted to add Bus Line #8 in between Lines 4 and 10), then other worksheets would create a blank row in which to fill the data in this new line.

Thanks,
Chad