+ Reply to Thread
Results 1 to 3 of 3

Need help to modify VBA code Drop down transfer lists

  1. #1
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Need help to modify VBA code Drop down transfer lists

    Is there anyway to modify the code below to recognize if cell M8 or cell M9 depending on which one is used can both transfer data over to another worksheet to the same row which is "Shop Log" range C . Both cells have drop down list but only one should be used at a time to transfer data over. What is happening is when cell M9 drop down list is used it keeps dropping my transfer data one row below because it thinks Cell M8 has transfer data as well even tho the cell is blank. Please see code below where the problem is highlighted in blue.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,996

    Re: Need help to modify VBA code Drop down transfer lists

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: Need help to modify VBA code Drop down transfer lists

    You saved the day Forum Guru. Thank you for your knowledge!

+ 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. [SOLVED] Need to modify VBA code to move Entries between Worksheets based on Drop-down Entry
    By loydancer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2015, 01:56 AM
  2. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  3. [SOLVED] VBA code to click/select drop down lists
    By hockeyadc in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-26-2013, 12:19 PM
  4. VBA Sheet array code not working with drop down lists in master sheet
    By chiplaidlaw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2012, 11:01 AM
  5. VBA code silently crashing. Problem with Data Validation drop down lists.
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-28-2012, 10:01 PM
  6. VBA code for Locking Cell disabling Drop Downs Validation Lists
    By Leox5000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2012, 08:43 AM
  7. drop down lists referencing tables creating other drop down lists!!
    By Stumped- in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-07-2009, 11:29 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