+ Reply to Thread
Results 1 to 5 of 5

How to populate cell based on drop-down list attached to the SAME cell?

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to populate cell based on drop-down list attached to the SAME cell?

    We have a resourcing spreadsheet to track utilization. For each month, I need to assign % FTE based on how long people work on an activity. To increase simplicity, I'd like to use a drop-down list of common times (e.g. 1/2 day, 1 day, 2 days, etc.) and based on the selection, that same cell is populated by the equivalent FTE (e.g. 0.02, 0.05, etc.)

    I've toyed with this, but keep getting a 'circular argument' warning. Even after the cell is populated with, say 0.02, I'd like the drop-down list to still exist and allow the user to make a different selection.

    I have created my drop-down list using the data validation within excel.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: How to populate cell based on drop-down list attached to the SAME cell?

    Hi,

    Don't think you can do that. The idea of data validation is that you are restricting the values that are allowed to be put in the cell to what is in the validation list.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    08-25-2010
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to populate cell based on drop-down list attached to the SAME cell?

    bttt - anyone? If it is in fact impossible, I can investigate alternate approaches.

  4. #4
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: How to populate cell based on drop-down list attached to the SAME cell?

    Can you post a sample. I adhere to the Domski's opinion, but nevertheless would like to see sample data.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, «Born in USSR»
    Vusal M Dadashev

    Baku, Azerbaijan

  5. #5
    Registered User
    Join Date
    08-25-2010
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to populate cell based on drop-down list attached to the SAME cell?

    Quote Originally Posted by contaminated View Post
    Can you post a sample. I adhere to the Domski's opinion, but nevertheless would like to see sample data.
    cell H4 is an example of the drop-down list I'd like to use. Based on the selection, I'd then like to populate that same cell with the corresponding value (% FTE) between K44 - K52.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1