LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Conditional listbox cell populating

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 :)
 
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
Populating listbox Mick[_2_] Excel Discussion (Misc queries) 1 May 14th 08 10:48 PM
populating a listbox enyaw Excel Programming 3 November 28th 06 06:48 AM
Populating a listbox will a certain cell on multiple worksheets in the activeworkbook KimberlyC Excel Programming 2 March 16th 05 12:49 AM
Populating listbox Andy Brown Excel Programming 3 August 16th 04 05:40 PM
Populating a ListBox ToddG Excel Programming 1 June 24th 04 03:18 AM


All times are GMT +1. The time now is 10:38 PM.

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

About Us

"It's about Microsoft Excel"