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

Code:

		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.

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..

Code:

Make: [Select from a pre-existing drop down list]
Model: [Drop down list populated dependant on the previous selection]
Results: List of results populated from the previous two selections - created by checking all existing spreadsheet

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]

Code:

JVC	GR-DVM76/96	Edit 100	Edit 110	Edit 120	
		Clips 100			
		Cirrus TLZ 5			
		Apex 100AW			
JVC	GR-DX25/77/95/97	Edit 100	Edit 110	Edit 120	Edit 120+
		Clips 100			
		Cirrus TLZ 5			
		Apex 60AW			
JVC	GR-FX15EK/SX25/FXM39E/SXM49/SXM58	Edit 140			
		Clips 140			
JVC	GR-SXM38	Edit 140			
		Clips 140			
JVC	GR-XM250US/740U	Edit 140	Edit 160		
		Clips 140			
JVC	GZ-HD3	Edit 110	Edit 120	Edit 120+	
		Clips 110			
		Apex 120AW

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.

Code:

JVC	GR-XM250US/740U	Edit 140	Edit 160	Clips 140
					
JVC	GZ-HD3	Edit 110	Edit 120	Edit 120+	Clips 110	Apex 120AW

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