happy_smiler1
New member
- Joined
- Aug 28, 2012
- Messages
- 67
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
Hi All,
I have two worksheets in a spreadsheet, I have a full address list in sheet 1, in sheet 2, is there any possible way to have data validation by where if the user clicks on an option then it will pull through all the data relating to that specific address?
E.g in my data validation list, the user clicks on "Home improvements", then in the rows beneath it, it will pull through all of the address relating to "Home Improvements" from sheet 1. Is this possible?
Thank You
I have two worksheets in a spreadsheet, I have a full address list in sheet 1, in sheet 2, is there any possible way to have data validation by where if the user clicks on an option then it will pull through all the data relating to that specific address?
E.g in my data validation list, the user clicks on "Home improvements", then in the rows beneath it, it will pull through all of the address relating to "Home Improvements" from sheet 1. Is this possible?
Thank You