Conditional listbox cell populating

  • Thread starter Thread starter Mardot
  • Start date Start date
M

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 :)
 
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
Click to expand...

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
 
Il 13/07/2013 15:39, GS ha scritto:
Not true!! The dependant DV lists offered there allow adding/deleting
rows (or cols).
Click to expand...
Thanks GS, next week it will be under investigation... :)
 
Back
Top