Excel - Drop Down Lists

[Lee24]

Hi all,

Here is my problem, I want ot be able to have 2 dropdown lists that if I selected a certain word in dropdown list 1 then dropdown list 2 only displays the values linked to the first value

Is this possible? Thanks In Advance Guys


any working examples wopuld be really appreciated

 

[GlennUK]

That's covered wonderfully in Debra Dalgleish's examples here:

http://www.contextures.com/xlDataVal02.html

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Lee24]

Thank for that, as i am fairly new to the excel scene (know the basics) what i am trying to do overall is

At present what happens is each user is sent an excel spreadsheet with cells to complete when they send it back the files are stored in a folder and a gather macro is used to collect certain criteria and paste it into a new spreadsheet what I want to do is simply

Create a data entry form that the users can access and complete and submit, this information is stored in an overall spreadsheet with a unique number (0001,0002 etc) then with this information create various reports


Do you know anywhere I could find working examples or point me in the correct direction.

 

[SkipVought]

"Do you know anywhere I could find working examples or point me in the correct direction."

1. No one is going to have anything that fits your requirements out of the box.

2. Glenn has already pointed you in the righ direction.

3. If you want specific help, you need to express your thoughts in a more coherent manner, clearly, concisely and completely.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Lee24]

I apologise for being unclear however I feel your response is rather abrupt... but its only my opinion

ok lets see if I can explain it more clearer than my last attempt

At present I send a form out to my staff to complete regarding hours worked

When I receive these forms they are stored on the network folder

I have a gather macro that picks certain elements of the individuals forms and places them into an overall spreadsheet

The question I am asking is that can a data entry form be used so that everyone can access simutaneously and when they hit submit or something similar there information is automatically logged into the "final" spreadsheet and given an unique number like 0001, 0002 etc

Thanks

 

[xlbo]

Yes and no

Yes - you can create a form that creates a unique number and dumps that into an excel spreadsheet along with other data

No - Excel is not the tool for getting people to simultaneously add / access data - that's what a database is for!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Lee24]

Ok thanks for the response, so now I know that one avenue not to go down is data entry (as I really need all the information) in Excel.

Do you have any suggestions on how to tackle my question?

Thanks

L

 

[SkipVought]

You are talking about a database manager, not a spreadsheet.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[xlbo]

If you need people to enter data potentially simultaneously, use MS Access. You can easily create a form to enter data into a table. You can then either use Access reports to present the info or export to excel and do it or query the access database from excel - there are loads of options

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Gavona]

How many users?

now I know that one avenue not to go down is data entry (as I really need all the information) in Excel.

Excel can pull information from Access so not necessarily a reason to reject the suggestion.

As an alternative e.g. if users don't have Access licences....

You could give each user a separate workbook and have a workbook that pulls the info from each source workbook.
Or give them all read only access to a single workbook that 'submits' their results to a separate csv or excel file for each user...with a 'data gather' workbook to consolidate.

We seem to have moved on from the original question!



Gavin