Filter / Macro Help.

[Ben_Holmes]

Hi,

I have a spreadsheet which contains the details of vehicles within a fleet.

I want to Input the registration nomber of the vehicle is a designated cell (D9) and then with the aid of a Macro click a button and the details relating to that vehicle will be filtered out from the table below.

Is this possible?

Thanks Ben

 

[erik.van.geit]

Hi, Ben,

to my sense you don't need a macro for this
take a look at VLOOKUP
1. you can do a search on this board (see link on top of this page)
examples
http://www.mrexcel.com/board2/viewtopic.php?t=175120&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=174839&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=170977&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=170377&highlight=vlookup
2. there are some good examples in the EXCEL-helpfiles

kind regards,
Erik