Storage location names auto insert

Hello Everyone,

I'm not sure where this should go because I don't know if you solve it with Visual Basic/macros/formulas.

At the moment I am trying to organize a storage room where I work. At the moment I do not have storage location names but for this thread we can say they run from 1A-200A

Attached is an edited version of the piece I am working on. I want to have a set of locations to be added into the log sheet automatically e.g the first storage box will be stored in 1A and when the form is filled out for box 2 it will automatically set 2A as the storage location. Each box will have an expiry date so when it reaches the expiry date I want that location to be free to enter again.

I hope this makes sense.

Any help is appreciated.

Orla
I have updated the excel file Please go into the TestLog file also I have asked this question on another forum maybe with better detail http://www.ozgrid.com/forum/showthre...398#post644398