Vlookup to leave values and disappear automatically
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
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/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
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.
Can someone help me out? I've seen a few macros that do this, but can't get them to work.
Hi,
Right-click the worksheet tab, then select View Code and paste this code in
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks