A
ali
Within the same Excel Sheet, I am creating an account profile sheet. I have
used Data Validation and lists to choose both the account name, and the data
fields. When I select the account name, I would like the appropriate data to
populate. I would like to have this 'stored' in one sheet versus several.
Ex, Account Name: <Microsoft>
Field 1: <apples>
Field 2: <oranges>
or if I choose...
Account Name: <XYZ>
Field 1: <lemons>
Field 2: <grapes>
Is there a way to do this?
used Data Validation and lists to choose both the account name, and the data
fields. When I select the account name, I would like the appropriate data to
populate. I would like to have this 'stored' in one sheet versus several.
Ex, Account Name: <Microsoft>
Field 1: <apples>
Field 2: <oranges>
or if I choose...
Account Name: <XYZ>
Field 1: <lemons>
Field 2: <grapes>
Is there a way to do this?