ClimoC
Well-known Member
- Joined
- Aug 21, 2009
- Messages
- 584
Hi all
I still need help on my other query if someone wants to show off their prowess...
This one, I have x number of dropdownlists using data validation. They all run across the top of the page - lets say each one is in A1, A2, A3, etc...
The data validation in all the lists is exactly the same
Each item in the dropdownlists matches the labels in the header row of sheet 1.
What I need is a macro which once run, will look at each of the values picked from the drop down lists, and then in a new sheet display that entire column that it matches to from Sheet1. So if I pick 'title' in the first dropdownlist, 'lineartx' in the second, and 'expiry' in the third, then in my new sheet I would see, side by side in columns A,B, and C, those three selected columns exactly as they are seen in Sheet1.
PS I can't use Autofilter because it would disrupt other functions.
Cheers
I still need help on my other query if someone wants to show off their prowess...
This one, I have x number of dropdownlists using data validation. They all run across the top of the page - lets say each one is in A1, A2, A3, etc...
The data validation in all the lists is exactly the same
Each item in the dropdownlists matches the labels in the header row of sheet 1.
What I need is a macro which once run, will look at each of the values picked from the drop down lists, and then in a new sheet display that entire column that it matches to from Sheet1. So if I pick 'title' in the first dropdownlist, 'lineartx' in the second, and 'expiry' in the third, then in my new sheet I would see, side by side in columns A,B, and C, those three selected columns exactly as they are seen in Sheet1.
PS I can't use Autofilter because it would disrupt other functions.
Cheers
