Hello, Im trying to setup a spreadsheet where I can use a list to select items only once until that item is returned.
We have batterys and solar panels that go out with our solar lighted real estate boards. The batteries and solar panels have numbers and I want to be able to add the battery and solar panel numbers used with the board number in a spreadsheet, but then that battery and solar panel number cant be used again until the board comes back and the items are returned.
Not sure where to start with this one so any help appreciated.
We have batterys and solar panels that go out with our solar lighted real estate boards. The batteries and solar panels have numbers and I want to be able to add the battery and solar panel numbers used with the board number in a spreadsheet, but then that battery and solar panel number cant be used again until the board comes back and the items are returned.
Not sure where to start with this one so any help appreciated.