Vlookup to leave values and disappear automatically

[astumpf13]

Hello,

I found a lot of manual ways, but I'm trying to make this as idiot proof as possible. When I select the "product category" on row 6, I have the values pulling into Row 25. I would like for the VLOOKUP to leave the values automatically to prevent user error? Is there an easy way to do this? Thanks!

Aaron

[MarvinP]

Hi Aaron and welcome to the forum,

I think you are looking for Cascading Dropdown Lists. You need to learn Named Ranges to the trick. See:

https://www.ablebits.com/office-addi...n-lists-excel/

[astumpf13]

Hi Marvin, It looks like all the values that I'm pulling in will be a drop down list thought. That's a lot of selection.

[astumpf13]

Can someone help me out? I've seen a few macros that do this, but can't get them to work.

[xlnitwit]

Hi,

Right-click the worksheet tab, then select View Code and paste this code in

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B6")) Is Nothing Then
        On Error Resume Next
        Application.EnableEvents = False
        Range("B25").Value = Application.VLookup(Range("B6"), Sheets("Minimum Information").Range("B:C"), 2, False)
        Application.EnableEvents = True
    End If
        
End Sub