At work, we are creating a register of all the boxes of archived files we have.
So what I want to do, is create a database, which will be placed on the
company network, which people can open, click a drop down list to select
which year, type, or invoice number they need to find. And it will return the
correct, corresponding box number.

I'm looking to create a sort of 'front office, back office' type of thing.
Like sheet 1 is where people will select what they're looking for, and sheet
2 will be where all the data is placed.

I thought I knew roughly how to do it. I know how to place the combo box and
suchlike.
Anyone offer help???

Much appreciated!!