seaching a Sheet

[RaelRigs]

Hi, i have a huge list over 7000 rows with all part numbers, Prices, order codes, i need on a day to day basis. i need to be able to search for a part number (i.e. AZ0231) to find current Prices for relevant items out of my lists.

Is there any way to filter out an entire row for example the same way the Auto Filter list does, but by typing in the part number im looking for in to a designated cell instead of selecting from a drop down list, so i can still see the other information relating to the part number in the adjacent cells


i have been using the Auto Filter feature so far but have found this to be very limiting in the size of the drop down list. its the same as looking through the sheet.

many thanks

RaelRigs

 

[RaelRigs]

many many thanks

i will give this a go and let you no how i get on.

once again

many thanks

RaelRigs