Apologies in advance if this should be in the VBA section but I'm hoping to accomplish with a formula (if possible but not 100% necessary if it will work without hiccups).
Rather than explaining and being long winded, I attached the workbook I'm dealing with. When we receive Final Estimates (via fax) we have to log it as received in the green section. No big deal. Then, when an employee goes to complete one they would fill out the blue section (not necessarily in the order received). I want the "LOG#" cell to automatically fill in with the next unused number (number list is on the "Log #'s" sheet).
Because it will autofill in when they are completed AND it needs to recognize that a number may be used already and out of order on page one (because of whenever it gets completed) I'm not sure the best way to do this (if I even can). Some sort of: If F4 contains data, then H4 inputs next chronological log number on Log #'s sheet that hasn't been used in Column H previously.
Finally, sometimes a final is removed altogether before it gets completed because it is no longer needed. If the data or row is deleted, will it prevent the formula/code from working?
I'd hope for something that isn't affected by a sort on any columns. Yikes!
At this point, I'm possibly thinking too hard and there is a simpler solution, but there may not be one? HELP!