Need Quote Sheet To Only Display Products with Quantities?

[aje35]

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

Quote Sheet

 

[lenze]

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]

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]

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