Need to hide linked rows based on condition

[janiangel]

I am creating a template to be used for calculating and preparing
sales proposal. Various parts of the proposal are created on differen
worksheets within the workbook, and are formatted to allow a certai
number of entries, say 50. The rows contain info such as quantity
description, and price. Usually, all 50 entries won't be needed, bu
sometimes they will.

Once the calculations have been performed, I need to compile th
proposal worksheet. I had planned to link the data from the variou
worksheets over to the proposal worksheet. However, I don't want t
include rows that have no quantity on the proposal sheet. Can
control this automatically, either at the time of updating the link, o
in formatting on the proposal worksheet

 

[Dave Peterson]

Any chance you could use Data|filter|autofilter.

then you can filter for values > 0 (or nonblank??).

The copy those visible rows whereever you want.

 

[janiangel]

Thanks for the response.! The only way I know to do that would requir
that the filter be run, and then the filtered cells could be pasted.
am wanting to link those cells, so that the user is not required to d
that step, and the final proposal page can be generate
"automatically". Do you know if that's possible

 

[Dave Peterson]

If it's possible, I think it would be an ugly formula--I still wouldn't do it.

Maybe you could have a macro that copies your data, deletes the 0 rows and does
more stuff, too???

 

[janiangel]

Thanks, Dave. I am not familiar with writing macros, but I guess now i
the time to learn. If that's what will do the trick, I'll head tha
direction.
Thanks, ever so much