Question Regarding Cell Selection

Zadjen · May 17th, 2002, 06:28 AM

I've created a spreadsheet for estimating costs of material. It is basically quite simple, a list of materials, each contaning the formula QUAN * PRICE = COST

My question is this: There are about 9 pages of items on the list, but for each estimate if you were only to select the items that were being used (where the cost was NOT zero), the page legnth would only be one or two pages.

How can I select only the cells that are not equal to zero and print them out in one list?

Thanks in advance!

mapakunk · May 17th, 2002, 06:37 AM

use an autofilter
highlight the row of column headers
Data -> filter -> autofilter
then on the drop down box that appears,
select custom filters
quantity column is greater than 0
you are in buisness

you can also record this as a macro and assign it to a button, that way all you have to do is push the button and it will sort 0 quantities for you, then record another macro where you sort quantity all items. assign it to a different button. Then all you have to do is click back and forth.

Robin · May 17th, 2002, 06:38 AM

Can you apply an autofilter and just look at the selected values using the Custom... feature?

Zadjen · May 17th, 2002, 06:44 AM

Ok, that's a step in the right direction. Here's the problem:

Thre are multiple heading rows, on for each different category of material. Using auto filter only works for the first category. Also, if there value is zero, it will still print the header which is not being used.

How can I use autofilter multiple times on the same work sheet, and how only print the headers that are being used for this particular estimate?

mapakunk · May 17th, 2002, 06:49 AM

Is there a reason they all have to be on one worksheet? It might be easier for you in the long run to have each estimate as a separate worksheet in the same file so you can just click the client's name below and get a sheet specific for them. That way you could do your individual auto filters. Otherwise I think you may need to delve into VBA for this, and I know nothing about that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 06:28 AM	#1
Zadjen New Member Join Date: May 2002 Posts: 2	I've created a spreadsheet for estimating costs of material. It is basically quite simple, a list of materials, each contaning the formula QUAN * PRICE = COST My question is this: There are about 9 pages of items on the list, but for each estimate if you were only to select the items that were being used (where the cost was NOT zero), the page legnth would only be one or two pages. How can I select only the cells that are not equal to zero and print them out in one list? Thanks in advance!

May 17th, 2002, 06:37 AM	#2
mapakunk New Member Join Date: May 2002 Posts: 40	use an autofilter highlight the row of column headers Data -> filter -> autofilter then on the drop down box that appears, select custom filters quantity column is greater than 0 you are in buisness you can also record this as a macro and assign it to a button, that way all you have to do is push the button and it will sort 0 quantities for you, then record another macro where you sort quantity all items. assign it to a different button. Then all you have to do is click back and forth.

May 17th, 2002, 06:38 AM	#3
Robin New Member Join Date: Feb 2002 Posts: 16	Can you apply an autofilter and just look at the selected values using the Custom... feature?

May 17th, 2002, 06:44 AM	#4
Zadjen New Member Join Date: May 2002 Posts: 2	Ok, that's a step in the right direction. Here's the problem: Thre are multiple heading rows, on for each different category of material. Using auto filter only works for the first category. Also, if there value is zero, it will still print the header which is not being used. How can I use autofilter multiple times on the same work sheet, and how only print the headers that are being used for this particular estimate?

May 17th, 2002, 06:49 AM	#5
mapakunk New Member Join Date: May 2002 Posts: 40	Is there a reason they all have to be on one worksheet? It might be easier for you in the long run to have each estimate as a separate worksheet in the same file so you can just click the client's name below and get a sheet specific for them. That way you could do your individual auto filters. Otherwise I think you may need to delve into VBA for this, and I know nothing about that.