Need Quote Sheet To Only Display Products with Quantities?

aje35

New Member
Joined
Jun 22, 2010
Messages
47
I have a product sheet with quantities for various products spec'd out for a designed system. The majority of products are not used on every system so their quantity value is 0. I am in the process of automating a quote sheet that gives a breakdown of what customers are being charged and I want it to populate items on this list only if their quantity is greater than zero. If anyone can assist I would greatly appreciate it.

Product Sheet
nbvrci.png


Quote Sheet
w1rop.png
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Hi and Welcome to the Board!!!
On your Product Sheet, just use Auto Filter on the Quantity column, Custom > 0 and copy the results to your Quote sheet. This can easily be written into a macro.

lenze
 

aje35

New Member
Joined
Jun 22, 2010
Messages
47
This was helpful however how do I have an entire group of cells on my Quote Sheet that replicates my Product Sheet so when a quantity is changed on the Product Sheet the Quote Sheet is changed.
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
We can probably work with that through VBA, but we need a wholelot more info from you!!
Sheet Names?
Lay out of each sheet??
How are cells changed?
A picture would help!!
lenze
Which cells are linked
 

Forum statistics

Threads
1,136,434
Messages
5,675,846
Members
419,586
Latest member
RoteichA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top