LinkBack URL
About LinkBacks
So here is my scenario:
Column A:
Cats
Dogs
Column B:
Tiger
Lion
Pugg
Beagle
So, if you select Cats in Column A - I only want you to see Tigers and Lions in Column B.
If you select Dogs - you see Pugg and Beagle.
How do i accomplish this?
Need to Validate Cell data based on input from other cell
So here is my scenario:
Column A:
Cats
Dogs
Column B:
Tiger
Lion
Pugg
Beagle
So, if you select Cats in Column A - I only want you to see Tigers and Lions in Column B.
If you select Dogs - you see Pugg and Beagle.
How do i accomplish this?
Check this example.
http://www.davesexcel.com/excelexamples.htm#857262960
This link has a few sub articles. Read through them but cant find something that applies to what I am looking for...
take a look at the attached, it is the same principle, just with different data. it uses named ranges and indirect()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hey,
This is exactly what I am looking for do and points me in the right direction. Thanks much.
glad to help and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks