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);

		Napoli 5	Napoli 10	Napoli 20	Napoli 30
Argus	DC-6340		Napoli 10		
Argus	QC-5340			Napoli 20	
BenQ	C840			Napoli 20	
BenQ	DC C1050			Napoli 20	
BenQ	DC C530			Napoli 20	
BenQ	DC C630			Napoli 20	
BenQ	DC C740i			Napoli 20	
BenQ	DC C750			Napoli 20	
BenQ	DC C820		Napoli 10		
BenQ	DC C850			Napoli 20	
BenQ	DC E100			Napoli 20	
BenQ	DC E520+		Napoli 10		
BenQ	DC E600		Napoli 10		
BenQ	DC E800		Napoli 10		
BenQ	DC X600	Napoli 5
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.