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!!

hi
not to sound discouraging or anything but i think your effords would be much
more furitfull in access. you could create your database in access and since
access and excel work quite well togeather, you could use excel via ms query
as the front end of your data base. i did it. i was managing some 30
reports(seperate excel files) in excel all of which got their data from an
access database. and some of the tables in access were in fact linked excel
files.
maybe not the best to go but when your dealing with people that just have to
see the results in excel.....well....you figure out a way.
it can be done in all in excel but excel was designed as a number cruncher
for accountants and for the most part remains as such. over the years, user
have tried to use excel as a data base with some success. microsoft has made
effords to accomedate these effords with new features, the news being uping
the row total to a millions rows in 2007. but it's still call spreadsheets.
my thoughts
regards
FSt12

"no-one-but-me" wrote:

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!!