Hello!
Wondering if there's a way to setup what amounts to an error check for overlapping entries in my sheet. I have a large warehouse containing product from multiple clients, and a workbook for each client to account for how much space within the warehouse I've allotted to that particular client.
The screenshot below is my entry form for assigning space and consists of drop-down menus to select the Aisle and start/stop slot numbers I want to assign to the client. The first entry for example would be Aisle M1, slots 1-40. Some of my clients have 20 different locations, so I'd like a column that checks all previous entries (searches upwards) for any overlapping assignments. I can do a lot with formulas, but haven't one clue how to even approach this one. A basic boolean formula with true/false would be wonderful. Ultimately I'd like to take it a step further to actually list what locations are overlapping, but beggers can't be choosers.
As always, any help or direction would be greatly appreciated.
Thanks again!
Zach
Wondering if there's a way to setup what amounts to an error check for overlapping entries in my sheet. I have a large warehouse containing product from multiple clients, and a workbook for each client to account for how much space within the warehouse I've allotted to that particular client.
The screenshot below is my entry form for assigning space and consists of drop-down menus to select the Aisle and start/stop slot numbers I want to assign to the client. The first entry for example would be Aisle M1, slots 1-40. Some of my clients have 20 different locations, so I'd like a column that checks all previous entries (searches upwards) for any overlapping assignments. I can do a lot with formulas, but haven't one clue how to even approach this one. A basic boolean formula with true/false would be wonderful. Ultimately I'd like to take it a step further to actually list what locations are overlapping, but beggers can't be choosers.
As always, any help or direction would be greatly appreciated.
Thanks again!
Zach