+ Reply to Thread
Results 1 to 2 of 2

Need Macro to change selection on drop down list on multiple rows based on entry in cell

  1. #1
    Registered User
    Join Date
    06-25-2015
    Location
    nigeria
    MS-Off Ver
    Mac Office 2011
    Posts
    1

    Post Need Macro to change selection on drop down list on multiple rows based on entry in cell

    Hello All,

    Please I have a table on Tab 'Log' which lists details of non functional assets entered daily.

    on Col R I want to change the entry on the dropdown list to 'Closed' for all rows with the same number on Col C

    For example For Rows 6 entered on Col C , entries in cells on Col R should change to Closed

    Please help !!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Need Macro to change selection on drop down list on multiple rows based on entry in ce

    "entries in cells on Col R should change to Closed"
    it means you will not be able to change the value of column R because there is only one value permitted
    - Battle without fear gives no glory - Just try

+ 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. Replies: 2
    Last Post: 07-15-2014, 08:24 PM
  2. Replies: 14
    Last Post: 08-10-2013, 04:07 PM
  3. Replies: 1
    Last Post: 04-12-2013, 06:27 PM
  4. Auto-Populate Data Entry Format Based on Drop Down Selection. Macro?
    By pro10is4life in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 01:16 AM
  5. macro to copy multiple rows based on cell entry
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2011, 07:23 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