+ Reply to Thread
Results 1 to 3 of 3

Reset data by selecting a pull down option?

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    Minneapolis, MN
    MS-Off Ver
    Minnesota
    Posts
    13

    Question Reset data by selecting a pull down option?

    Looking for a macro (or maybe a function I don't know of) that will reset my counted data when a certain data validation option is selected. Right now my spread sheet will say the sum of an input quantity, the status (either "pending" or "release"), and the WO released (my data validation) which gives the options of yes or no. When the WO Released is selected to say "yes" the status is switched back to pending. The only issue is that when it says "yes" the data (the inputted quantity) doesn't reset. I also want there to be a way so that the next time a quantity is inputted that WO Release goes back to "no".

  2. #2
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Re: Reset data by selecting a pull down option?

    Can you attach a sample copy of the data?

  3. #3
    Registered User
    Join Date
    02-11-2019
    Location
    Minneapolis, MN
    MS-Off Ver
    Minnesota
    Posts
    13

    Re: Reset data by selecting a pull down option?

    Here is a sample work book. The tabs are labeled BEFORE for my current state and AFTER for what I want to accomplish. I added notes for what exactly I am trying to do. Start from the first "BEFORE" worksheet and work your way over. Let me know if anything is unclear.
    Attached Files Attached Files
    Last edited by heggej; 02-13-2019 at 10:04 AM.

+ 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. solution to chnage the serial number while selecting Data filters option
    By Kaleemuddin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-07-2017, 08:42 AM
  2. Option Button to Pull Data from Another Sheet
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2016, 12:16 PM
  3. Auto-fill Data When Selecting Option From Drop-Down List
    By patrickdjames in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-25-2013, 11:49 AM
  4. Replies: 0
    Last Post: 04-16-2012, 05:21 AM
  5. Automatically Selecting An Option in a Data Valdidation Cell
    By soteman2005 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2006, 07:55 AM
  6. reset option buttons
    By raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2005, 06:58 PM
  7. Navigating between option buttons is not selecting the option
    By Ramana in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-03-2005, 10:05 AM

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