+ Reply to Thread
Results 1 to 8 of 8

Auto select multiple drop down menu base on the info I entered on a specific column

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Monterey Park, Ca
    MS-Off Ver
    Excel 2010
    Posts
    34

    Auto select multiple drop down menu base on the info I entered on a specific column

    So tired to work day and night for it, lack of sleep is killing me . Hope you guys can help!!!

    Subject: CSV product upload
    Problem: Too time consuming to select categories and attributes one product at a time
    Attribute Definition: A left side sorting menu on ecommerce website Example: Color - Blue, Green, Yellow or Length - 10" to 15", 16" to 21", 22" to 30 and above
    Seeking Solution: Manually type a good description on the Product Title Column, then the categories and attributes drop down menu will be automatically select based on the Product Title Column.

    Please see attachment for sample. Since the forum doesn't allow me to upload Macro file, therefore, the drop down will not work. Let me know if you would like to see the Macro version, I can email it to you or put it in my dropbox for you.

    Hope you guys can help me, it will save me hours of work, truly Appreciate!!!
    Attached Files Attached Files
    Last edited by juno612; 06-21-2014 at 02:05 PM.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Auto select multiple drop down menu base on the info I entered on a specific column

    you could show the macro

  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    Monterey Park, Ca
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Auto select multiple drop down menu base on the info I entered on a specific column

    I clicked on upload, the macro file didn't show up. Then I used basic upload, I found the file but when I tried to upload it. It said invalid file.

    It's .xltm format...

    Thanks,

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Auto select multiple drop down menu base on the info I entered on a specific column

    Try copying and pasting the macro only.

  5. #5
    Registered User
    Join Date
    09-20-2012
    Location
    Monterey Park, Ca
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Auto select multiple drop down menu base on the info I entered on a specific column

    Sorry, tried that. Actually the macro only putting the category ID to the 4th column when a drop down menu selected and that's it. So hope it is clear enough to understand my question. Thank you for your suggestion

    By the way, does anyone have idea how to solve my issues? Appreciate

  6. #6
    Registered User
    Join Date
    09-20-2012
    Location
    Monterey Park, Ca
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Auto select multiple drop down menu base on the info I entered on a specific column

    Here is the Macro, thanks

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim rngDV As Range
    Dim oldVal As String
    Dim newVal As String
    Dim lUsed As Long

    If Target.count > 1 Then GoTo exitHandler

    On Error Resume Next
    Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
    On Error GoTo exitHandler

    If rngDV Is Nothing Then GoTo exitHandler

    If Intersect(Target, rngDV) Is Nothing Then
    'do nothing
    Else
    Application.EnableEvents = False
    newVal = Target.Value
    Application.Undo
    'oldVal = Target.Value
    Target.Value = newVal
    'If Target.Column = 3 Then
    Cells(Target.row, 4).Value = opRange(Target.Value, Target.row, 4)
    End If
    exitHandler:
    Application.EnableEvents = True
    End Sub

  7. #7
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Auto select multiple drop down menu base on the info I entered on a specific column

    At most, the macro only fills the cell in column D for the target.row, so what else do you need to fill? The rest are controls that mostly point to the exit door

  8. #8
    Registered User
    Join Date
    09-20-2012
    Location
    Monterey Park, Ca
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Auto select multiple drop down menu base on the info I entered on a specific column

    Yes, the Macro above only fill the cell in column D. What I really need is:

    We enter our product title in Column E, then both Category ID (Column D)and attributes (Column FGHI) should be automatically selected based on the information we entered on the column E. By the way, those attributes are drop down menu, not sure if it matters.

    Thanks RCM

+ 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] If I select an option from a drop-down in 1 cell, how do i get it to display specific info
    By Posthuman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2012, 01:45 PM
  2. select multiple items from drop-down menu
    By jcavigli in forum Excel General
    Replies: 2
    Last Post: 05-25-2008, 11:50 AM
  3. Getting info from drop down menu
    By excelpoepol in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2007, 03:31 AM
  4. [SOLVED] Getting Info From Drop Down Menu
    By Paul S in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2006, 11:45 AM
  5. When I select from drop down menu I would like the next column to populate a specific cost.
    By missmarley@gmail.com in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2006, 07:25 PM

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