Advanced Data Filter

[eddieRoberts]

Dang you guys we are so darn close!

I am going to not talk hypothetically anymore so I can follow hahah.

Ok on a sheet called "Options"
I have a List of things you could choose to put into your new house

Column A is where you would put your x to choose. I have over 30 rows to choose from

Column B is the item Price

Column C is the description

I need everything that is chosen in column A
To appear on a new worksheet.

The formulas that you guys gave me only brought over the First Item chosen and nothing below it. Sorry for being a pest, i just have to get this done before 7 am

 

[Aladin Akyurek]

On 2002-10-23 19:56, eddieRoberts wrote:
Dang you guys we are so darn close!

Try the solution given anew. You only need to adjust the source sheet name (Sheet1 --> Options) and the range for the Range list.

 

[eddieRoberts]

Im ignorant , but not that BAD

Ive been able to follow along.
Its just not placing all of the selected Items from the other sheet, just the first selected item

 

[Yogi Anand]

Hi eddieRoberts:

I don't see Aladin around -- so what is the issue now with the Advanced Filter -- I gave you a step by step description on what was in my worksheet simulation in regard to the problem you posted with the x's.

Have you used Colo's utility? Can you post your data? Otherwise I will give you my email address -- so you can email me your worksheet and then I can get back to you.

Regards!

Yogi Anand

 

[eddieRoberts]

Id like your email so that I can get assitance. Mine is ed@markermodularhomes.com
PLEASE HELP!

 

[Aladin Akyurek]

On 2002-10-23 20:07, eddieRoberts wrote:
Im ignorant , but not that BAD

Ive been able to follow along.
Its just not placing all of the selected Items from the other sheet, just the first selected item

Working with Advanced Filter is not hassle-free. Filtering to another worksheet can be very unnerving. It's difficult to assess why you'd get a single record. In the source data there should be no extra spaces around "x"...

 

[Yogi Anand]

On 2002-10-24 01:31, eddieRoberts wrote:
Id like your email so that I can get assitance. Mine is ed@markermodularhomes.com
PLEASE HELP!

Hi Ed, to be able to effectively use Advanced Filter to extract selected items from the Options Sheet to the CustomerQuote Sheet, you have to rearrange the data a little as I have delineated in my notes to you via email. Following simulation shows data extracted from the Options Sheet:

MPQUOTE2a.xls
	A	B	C	D	E	F	G
1	HouseModelNumber	M7036		OptionSelected
2	BasePrice	$63,723.53		x
3	Options
4
5				OptionSelected	Item	Price	Description
6				x	FloorPlanOptions
7				x		350	GarageApplicationFrontLoad
8				x		25	GarageApplicationEndLoad
9				x	RoofOptions
10				x		1295	70#G.S.L./70#L.L./"16O.C.Ranches
11				x	KitchenCounter
12				x		STD	Carrara
13				x	2ndBathCounter
14				x		STD	Sky
Customer Quote

</SPAN>

Regards!

Yogi Anand