Hey all,
I'm in need of help. I'm creating a database that will have around 20,000+ cells with times in them. I'm looking to make a easier way around entering said times manually. I've created a separate sheet to enter the multiple criteria to look for and once I've entered the time into that I want it to filter into the appropriate cell if that makes sense. Please see attached screenshots. However what I want is for when I change the criteria the value doesn't then get removed.
On Capture 3 this is the formula I have
Bookmarks