2 Queries (Searching and emails)

Hi,

Firstly, thanks for reading my post.. and hopefully for replying with suggestions.

--

This is the basics..

I'm the latest version of Office, running a Excel file in compatibilty mode for Office 2007 etc (So I can use the database in work).

I have a camera case database, which I created using information found on the internet (mainly lowepro.com) which saves myself, and some colleagues a fair amount of time during our daily roles.

I currently have 14 different worksheets (Index, Apex, Cirrus, Clips, d-Pods, Edit, Lens, Napoli, Rezo, Ridge, Spectrum, Tasca, Search, batteries) within the database, and I'm tring to provide 2 more things to assist people who do attempt to utilise the database.

1) Search feature
2) Email form

Heres a sample from one of my worksheets (Napoli);

Please Login or Register  to view this content.

1) I've played around using vlookup and hlookup to very little avail.

I really would like a simple search feature, on a different sheet - which will enable the end users to select from the one form.. a 'Make' (from a predetermined drop down list), 'model' (again from drop down list, thats determined by the 'Make'), which will then either show all the results from each worksheet.. or if thats a bit too messey, to have a 3rd drop down list that preselects the case type [worksheet].

2)

My database is read-only to prevent users accidently editing the information - But I'm still trying to find a way of creating a email form, with editable areas for the user to fill in.. with a simple 'click here to send email' type button that will email me directly.

I don't think this will be possible, as the entire file is read-only.. but theres no harm in my asking.


Any help would be much appreciated.

question 2) has been resolved.. 9using teh search function on here.. found http://www.rondebruin.nl/sendmail.htm which is ideal so thx for that)

still stuck on 1) though

Still no joy with implementing some sort of search feature..

All I want it to do.. is output results like this..

Please Login or Register  to view this content.

Righteo.. still searching for a solution to Question 1)

I've been playing around with the format I've got the data stored in.. I've now (mostly manually.. i now have a couple of sore fingers )..restructed all the information from the differing sheets into the one worksheet.

So, my questions have now changed slightly..

1) Still need a method too search.. [See previous posts]

&

2) Is there a way for me to reformat all of my data automatically, without hurting my fingers some more? [See below for samples]

Please Login or Register  to view this content.

The above is a snippet from the worksheet..

I need to somehow restructure it into something more like the following; with all the relevant information contained on the one line/row but 'not' merged into the one cell.

Please Login or Register  to view this content.

I've been looking, but perhaps I'm just not searching properly.. But I cant find anything to solve this.