+ Reply to Thread
Results 1 to 6 of 6

Dynamicly update cells based on list?

  1. #1
    Forum Contributor
    Join Date
    08-31-2010
    Location
    andover
    MS-Off Ver
    Excel 2007
    Posts
    102

    Dynamicly update cells based on list?

    Hello all.

    I have a number of cells with pop up boxes with for instance dates to select.

    These are linked via data validation to some dynamic ranges on another sheet.

    If I change the date from say 1st march to 1st april in the dynamic range, the cells which currently have 1st March in stay that way.

    Is there a way for that cell to realise I swapped out March for April and change accordingly?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Dynamicly update cells based on list?

    Hello,

    if you have data validation in a cell, select a value from the data validation list, and after that change the data validation source, the value in the cell will not change automatically.

    Post a workbook with some sample data and explain the bigger picture.

    Why do you change the data validation source? How do you change it?

    You will probably need VBA to reset the value in the cell, but to give more detailed suggestions, you'd better post a workbook that details the concept.

    cheers,

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Dynamicly update cells based on list?

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Contributor
    Join Date
    08-31-2010
    Location
    andover
    MS-Off Ver
    Excel 2007
    Posts
    102

    Re: Dynamicly update cells based on list?

    hi There.

    I am not sure an example sheet will help in terms of what I need.

    However I have attached one. The first cell is data validation referencing the dates there. If I change say 2nd March to the 10th March I want the the first cell to automtically change to that date but currently it does not the user has to pick fromt he list again.

    The reason I need to do this is because its for a mobilisation plan excel sheet and for a new business the dates will obviously change per new business, but the general structure will remain the same, so I want to be able to change the dates in the dynamic list and these dates update in the cells. But the user needs to be able to pick different dates if needed!
    Attached Files Attached Files

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Dynamicly update cells based on list?

    So, can you explain the rules you want to apply?

    If your data validation list has 4 dates, and the user picks the second date in the list.

    Then you change the dates that are the source for the data valuation. Which date should then appear in the cell? The first date of the list? The second date?

    Any logic that can be put into words? A solution can then be worked out with VBA.

    cheers

  6. #6
    Forum Contributor
    Join Date
    08-31-2010
    Location
    andover
    MS-Off Ver
    Excel 2007
    Posts
    102

    Re: Dynamicly update cells based on list?

    Hello Teylyn, I guess I was hopeful it was just a checkbox I had to tick!

    Basically I guess I need to tell the system that if the third entry in the list is changed and the cells value is equal to the third entry of the list then change that to the new item added.

    Or if the third entry in the pick list is 3rd march and I change it to 10th march, all cells that were 3rd March should now change to 10th March

    Of course if there is a simplier or better way to achieve this I am open to offers! I was thinking of the calender pop up box, but got a bit lost with that one to be honest.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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