I am creating a form to add the operating hours for four different engines into a different sheet for each of the engines. The engineer will select an engine from the drop-down, enter hours and hit the button. The Hours and Date+Time (NOW function), will get added to the database. The other columns (Service at, Overhaul at and Hours until Service) will use the Hours data added through the form. Attatched is what I have so far, I just don't get how to get it to sort data by engine through the drop down. Any help would be much appreciated!
Bookmarks