ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,194
- Office Version
- 2007
- Platform
- Windows
Hi,
On my worksheet in column B i have a list of vehicles.
These vechiles at present are unsorted because column D is in the A-Z sort option.
Imagine the vehicles are.
ACCORD
CIVIC
INSIGHT
JAZZ
ETC ETC & there are many instances of the same car.
So when column B is sorted A-Z so ACCORD has 55 rows followed by CIVIC with 104 rows etce etc.
I need to make a userform which each model of vehicle in the list so when i click say INSIGHT i would like to be taken to the first instance of INSIGHT
Currently im scrolling through lots of rows before i even get to the I section.
On my worksheet in column B i have a list of vehicles.
These vechiles at present are unsorted because column D is in the A-Z sort option.
Imagine the vehicles are.
ACCORD
CIVIC
INSIGHT
JAZZ
ETC ETC & there are many instances of the same car.
So when column B is sorted A-Z so ACCORD has 55 rows followed by CIVIC with 104 rows etce etc.
I need to make a userform which each model of vehicle in the list so when i click say INSIGHT i would like to be taken to the first instance of INSIGHT
Currently im scrolling through lots of rows before i even get to the I section.