Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ben h
 
Posts: n/a
Default custom dependent list validation

Hi,

This is for our timesheets. We have two lists that I'm interested in
speeding up: client list, job activity list.

Clients are represented by their names (easy so far), e.g. NPR, NASA,
Orange...

Job activities are represented by the first letter of the client name,
then some numeric codes, e.g. N05015-100, N05015-200, N05016-100,
N05016-110, N05016-120, N05016-130, O05019-200. There are many job
activities to each client.

These lists are in my worksheet:

Clients Jobs
Alpha A05001-100
Beta A05001-200
NPR A05001-300
NASA A05001-310
Orange A05001-320
Zylex A05001-330
A05001-340
A05001-400

and so on.

The timesheet has one cell for the client, then the next (adjacent) cell
is for the relevant client job for that entry. How can i make the second
cell only display the relevant job numbers for the client? I really
don't care if for client NPR all the jobs for NPR and for NASA are
displayed; that's loads better than nearly a hundred jobs displaying for
every client. In other words i want to filter on the first letter.

Does this make sense? Can it be done with some sort of function in the
data validation dialog? Will it need a VBA solution?

Thanks for any help!

Ben
  #2   Report Post  
Rowan Drummond
 
Posts: n/a
Default custom dependent list validation

Maybe this will point you in the right direction.

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

Hope this helps
Rowan

ben h wrote:
Hi,

This is for our timesheets. We have two lists that I'm interested in
speeding up: client list, job activity list.

Clients are represented by their names (easy so far), e.g. NPR, NASA,
Orange...

Job activities are represented by the first letter of the client name,
then some numeric codes, e.g. N05015-100, N05015-200, N05016-100,
N05016-110, N05016-120, N05016-130, O05019-200. There are many job
activities to each client.

These lists are in my worksheet:

Clients Jobs
Alpha A05001-100
Beta A05001-200
NPR A05001-300
NASA A05001-310
Orange A05001-320
Zylex A05001-330
A05001-340
A05001-400

and so on.

The timesheet has one cell for the client, then the next (adjacent) cell
is for the relevant client job for that entry. How can i make the second
cell only display the relevant job numbers for the client? I really
don't care if for client NPR all the jobs for NPR and for NASA are
displayed; that's loads better than nearly a hundred jobs displaying for
every client. In other words i want to filter on the first letter.

Does this make sense? Can it be done with some sort of function in the
data validation dialog? Will it need a VBA solution?

Thanks for any help!

Ben

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Adding entry to validation list without retyping all lists BB Excel Discussion (Misc queries) 2 June 14th 05 10:26 PM
Show comma in data validation list? [email protected] Excel Discussion (Misc queries) 7 May 17th 05 02:07 AM
Validation - List - Separate Worksheet J. Osborne Excel Worksheet Functions 1 October 28th 04 04:23 PM


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"