+ Reply to Thread
Results 1 to 4 of 4

Make data stay when referecen fields change

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2016 & 365
    Posts
    49

    Make data stay when referecen fields change

    Hello,

    Thanks in advance. I appreciate any efforts to help with my question. I have a project that I am using drop down lists to fill in information into 4 cells which then populate a response to a specific cell in a grid based on the drop downs selected. Is there a way for me to make that populated specific cell information stay in the cell and then restart the choosing process for another cell with the same drop down lists?

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Make data stay when referecen fields change

    Hi, your question is quite unclear?
    If you have a value in a cell even if it's from a dropdown list it's there, unless you clear the cell's value.
    How about a sample file? Are you using macro's?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    11-09-2012
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2016 & 365
    Posts
    49

    Re: Make data stay when referecen fields change

    Hi Keebellah,

    I do not have an example at this time. I don't really want to go through work to get the first part to work if I can not get this last piece working. However, I will try to put something together and re-ask the question. Thank you for your time.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Make data stay when referecen fields change

    Sorry, but do you even know aht you're asking?
    It sounds very vague.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make fields clickable to sum up data
    By Pagelite in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 01:43 PM
  2. Make a form stay at the front?
    By Neil Ives in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2011, 06:57 AM
  3. Make a formula stay in a cell
    By Jvic28 in forum Excel General
    Replies: 2
    Last Post: 05-20-2010, 05:12 AM
  4. INDIRECT FUNCTION - how to make data stay permenantly
    By Robotacha2010 in forum Excel General
    Replies: 5
    Last Post: 12-09-2009, 12:02 PM
  5. Make CommandButton stay as row height changes
    By okriskao in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2009, 04:11 PM
  6. Make numbers in formula stay the same
    By Rochy81 in forum Excel General
    Replies: 2
    Last Post: 10-02-2008, 01:29 PM
  7. Replies: 2
    Last Post: 07-11-2006, 03:40 PM
  8. make colour in rows stay
    By Crowraine in forum Excel General
    Replies: 1
    Last Post: 01-28-2005, 02:06 PM

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