+ Reply to Thread
Results 1 to 1 of 1

Formula drops in a cell w/ Data Validation

  1. #1
    Registered User
    Join Date
    10-26-2016
    Location
    Saint Cloud, FL
    MS-Off Ver
    2013
    Posts
    1

    Question Formula drops in a cell w/ Data Validation

    I am working on a spreadsheet that has several cells that have data validation. Part of the intention of the cells is to allow the users to select multiple items from the drop-down menu. In order for that to work, I've had to add a macro that allows for several items to be selected from the drop-down menu.
    Here is the code for the macro:

    Please Login or Register  to view this content.
    The users of the spreadsheet wanted what they filled into one cell to auto-fill into the other cells in the column. So, at first I created a macro that basically allowed them click a button and it would auto-fill. However, I think there is an issue with this:
    1.The button macro fills in all the cells in column 2. I couldn't find a way for the macro to perform an if function. So, if they put names in column 1, I had to have it flow to all of the potential selected cells in column 2. I really just wanted to it to flow to the cell in column 2, if there is a name in column 1.


    So, I decided to use an IF formula: =IF(ISTEXT(A13),B12,"") But when I put that formula into the cells and hit enter, the formula disappears.

    I know it has something to do with the target value in the macro, but I don't know how to fix it. I need the code in the macro, so they can select several options from the drop-down but I also need the formula to remain.

    Any thoughts or suggestions?
    Last edited by JBeaucaire; 10-27-2016 at 12:07 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. Data Validation drops data in each line
    By old dawg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2016, 01:51 PM
  2. E-mail automaticly send if value of cell drops below 90
    By InvalidTxtString in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2016, 11:59 AM
  3. Data Validation - Formula in Cell Not allow any changes
    By loverfellow in forum Excel General
    Replies: 2
    Last Post: 11-11-2015, 10:15 AM
  4. excel formula working on a cell which is having data in a data validation cell
    By sujithy007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2013, 04:18 AM
  5. excel formula working on a cell which is having data in a data validation cell
    By sujithy007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 04:05 AM
  6. [SOLVED] Using formula on a cell with data validation
    By shawnsonline in forum Excel General
    Replies: 6
    Last Post: 08-10-2012, 05:31 PM
  7. A macro to help me enter data per row and then drops down to the next row to input more.
    By DorothyFan1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-30-2012, 10:36 AM

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