Can drop downs be narrowed based on dynamic data entry?

R

Roady

I have a worksheet#1 that is filled in with data in columns A-D but then that
data needs to feed to another worksheet (#2). (worksheet 1 is entered by Bob
and then worksheet 2 is entered by Mary who then makes choices based on what
was entered in worksheet 1). How can I make this happen? I will put an
example below to explain further.
A1= Fruit A2=Orange A3= CAlifornia A4= LA
B1= Fruit B2= Apple B3= Vermont B4= Springfield
C1= Vegatables C2= Potato C3= Idaho C4= Boise
So, in the above example, if the person selected Fruit from the dropdown in
Column A (worksheet #2), they would then need to only see the options for
Orange or Apple. Then, lastly, once they had chosen orange or apple, columns
C and D would autofill with their respective state and city (no dropdown-
just autopopulate). Is that possible? I obviously can't do named ranges since
the data is dynamic and will change over time. Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Count no. of occurance in 2 dynamic columns within a data period 7
Creating a high performance dynamic name 2
Script to Split up Worksheet into Multiple Sheets based on a Columnof Data 1
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
MS Query Refresh Based on Dynamic Named Range 0
Data validation drop downs don't recognize dynamic named range 0
Force entry into cell, based on validation selection in adjacent cell 3

Top