tring to add a search cell

[jamtay317]

I have a data base that I want to search where if I type Sm* it will bring up all of the last names that start with Sm. also useing the same cell I would like to be able to search lot numbers and sales order numbers. I have a data set, please tell me what or where I need to add for someone can help me with the VBA code.

 

[Aladin Akyurek]

yes, I can please tell me how? also not sure what your asing me to post also

Borders-Copy-Paste

A very small sample would possibly suffice.

 

[jamtay317]

count 1 4 <tbody> </tbody> Search jeff date Sorder Number Last Name First Name Address City Flooring type Total Gearries Jeff 5821 Mustang Ct Indianapolis Retail full spread $334.74 <colgroup><col><col><col><col span="2"><col><col><col><col span="2"></colgroup><tbody> </tbody>

<tbody>
</tbody>

is where I'm tring to index it

SOrderNumber	invoiceNumber	Date	Billing Number	Last	First	Address	Sq Footage	Flooring Type	GroutColor	Total	City	State
13606	13818			Hampton	0	20902 Freemont Moore Road	20	Builder backsplash diagonal		$300.00	Westfield	IN
13586	13824			Loyal	Joyce	3617 Tiara Ct	0	0		$45.00	Indianapolis	IN
13750	13825			Archie	Betsy	10923 firefly Ct	0	0		$160.00	Indianapolis	IN
13873	13871			Sumerset	58	11624 Cannington Cir	0	0		$130.00	Fishers	IN
13378	13858			Place	4 Stafford	14534 Alderbrook Trail	1	Builder fireplace		$95.00	Carmel	IN
13682-0	13857			Brookheaven	102	2708 Benmore Ct	505	Builder straight		$2,144.00	Zionsville	IN
13320	13738			Builders	Shamrock	9800 Westpoint Dr	0	none		$277.00	Indianapolis	IN
13506	13977			lakeside	213	13995 amblewind place	24.5	Builder backsplash straight		$294.00	carmel	IN
13941	13949			Basham	Virginnia	5801 Lawton Loop E. Dr Unit 5	264	Retail full spread		$205.92	Indianapolis	IN
13682-1	13857			Brookheaven	102	2708 Benmore Ct	90	Builder diagonal		$698.00	Zionsville	IN

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

this is where the data is....

 

[jamtay317]

did anyone have any other ideas?

 

[Aladin Akyurek]

did anyone have any other ideas?

The sample is, posted in 2 parts:

A:F, say, from row 1 on...

SOrderNumber	invoiceNumber	Date	Billing Number	Last	First
13606	13818			Hampton	0
13586	13824			Loyal	Joyce
13750	13825			Archie	Betsy
13873	13871			Sumerset	58
13378	13858			Place	4 Stafford
13682-0	13857			Brookheaven	102
13320	13738			Builders	Shamrock
13506	13977			lakeside	213
13941	13949			Basham	Virginnia
13682-1	13857			Brookheaven	102

<colgroup><col style="width: 96pt; mso-width-source: userset; mso-width-alt: 4551;" width="128"> <col style="width: 112pt; mso-width-source: userset; mso-width-alt: 5290;" width="149"> <col style="width: 48pt;" width="64"> <col style="width: 101pt; mso-width-source: userset; mso-width-alt: 4778;" width="134"> <col style="width: 105pt; mso-width-source: userset; mso-width-alt: 4977;" width="140"> <col style="width: 101pt; mso-width-source: userset; mso-width-alt: 4807;" width="135"> <tbody>
</tbody>

and G:M...

Address	Sq Footage	Flooring Type	GroutColor	Total	City	State
20902 Freemont Moore Road	20	Builder backsplash diagonal		$300.00	Westfield	IN
3617 Tiara Ct	0	0		$45.00	Indianapolis	IN
10923 firefly Ct	0	0		$160.00	Indianapolis	IN
11624 Cannington Cir	0	0		$130.00	Fishers	IN
14534 Alderbrook Trail	1	Builder fireplace		$95.00	Carmel	IN
2708 Benmore Ct	505	Builder straight		$2,144.00	Zionsville	IN
9800 Westpoint Dr	0	none		$277.00	Indianapolis	IN
13995 amblewind place	24.5	Builder backsplash straight		$294.00	carmel	IN
5801 Lawton Loop E. Dr Unit 5	264	Retail full spread		$205.92	Indianapolis	IN
2708 Benmore Ct	90	Builder diagonal		$698.00	Zionsville	IN

<colgroup><col style="width: 208pt; mso-width-source: userset; mso-width-alt: 9841;" width="277"> <col style="width: 84pt; mso-width-source: userset; mso-width-alt: 3982;" width="112"> <col style="width: 181pt; mso-width-source: userset; mso-width-alt: 8561;" width="241"> <col style="width: 97pt; mso-width-source: userset; mso-width-alt: 4579;" width="129"> <col style="width: 103pt; mso-width-source: userset; mso-width-alt: 4864;" width="137"> <col style="width: 86pt; mso-width-source: userset; mso-width-alt: 4067;" width="114"> <col style="width: 48pt;" width="64"> <tbody>
</tbody>

Would you specify in words, not with formulas, what you need to do with this data?

 

[jamtay317]

I would likeif I type in the criteria cell from any of these " SOrderNumber, Last, or Flooring_Type" ranges to display the records for that criteria

 

[Aladin Akyurek]

I would likeif I type in the criteria cell from any of these " SOrderNumber, Last, or Flooring_Type" ranges to display the records for that criteria

All of SOrderNumber, Last, or Flooring_Type or a combination of them, including just one of them?

 

[jamtay317]

if i type just "man" in f3 and in SOrderNumber, flooring_type, and last have something with"man" in it I want it to pull up

 

[Aladin Akyurek]

if i type just "man" in f3 and in SOrderNumber, flooring_type, and last have something with"man" in it I want it to pull up

Probably missed, but I don't see any item containing "man". Don't take this observation wrong. It's vital to know what happens if the substring one is looking for appears more than once in the same row (record) under the relevant fields. I assume the record (the whole record actually) constitutes a result to report. Right?

 

[jamtay317]

ok, I would say that if there is a number look up, like sales order number, then yes it could be in the address portion of the row, but if I'm looking up "man" that would just be under the last name

 

[jamtay317]

also, there is about 2000 records in this data that is the reason that there isnt a "man" in the data set that you saw.