Conditional listbox cell populating

[Mardot]

Hello, just a simple (for you) question.

I'm trying to realize a very basic Timesheet for my company.

I have a sheet ("Project Activities") in wich I have two columns:
COLUMN A: PROJECTS
COLUMN B: PROJECT ACTIVITIES

Of course I can have multiple rows with the same Project Code, because
for each project I can have more than one project activity.

Example:
Proj1 | Activity1
Proj1 | Activity2
Proj1 | Activity3
Proj2 | Activity1
Proj3 | Activity1
Proj3 | Activity2
Proj3 | Activity3

So, into another sheet ("Timesheet") I would like to populate the first
cell with the list of the projects, ignoring the double values.

Then, once I selected the project from the first list, I'd like to
select the project activity from the second cell, by populating the list
of the values I can select, with the activity of the selected project only.

Then, when the user will have been selected Project and Project
activity, he will put the number of the hours used for that activity, stop.

So, summarizing, I need the way to populate a cell with the project list
indicated into the column A, ignoring multiples values. Then, once I
selected the project from the list, I need to populate the second cell
by a list of the activities associatied to the project just selected
into the first cell.

Tnx and bye

 

[GS]

Here's a good place to start...

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

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mardot]

Il 10/07/2013 17:04, GS ha scritto:

Here's a good place to start...

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

Thanks, I already saw this page.
Unfotunately I'm looking for a different solution, as I described in my
original post, because I would like to arrive to a dynamic solution, in
which if I add some row to my sheet, it will still work as well.
Regards, Marco

 

[GS]

Il 10/07/2013 17:04, GS ha scritto:

Thanks, I already saw this page.
Unfotunately I'm looking for a different solution, as I described in
my original post, because I would like to arrive to a dynamic
solution, in which if I add some row to my sheet, it will still work
as well.
Regards, Marco

Not true!! The dependant DV lists offered there allow adding/deleting
rows (or cols).

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mardot]

Il 13/07/2013 15:39, GS ha scritto:

Not true!! The dependant DV lists offered there allow adding/deleting
rows (or cols).

Thanks GS, next week it will be under investigation...