mving select data (var # of cells) frm a range to another workshee

  • Thread starter Thread starter Galen
  • Start date Start date
G

Galen

I have a workbook that is pulling data from one worksheet to another using
the sumif() function and i want to then display this information in another
"summary" worksheet that only displays cells that have a non-zero value... do
i need to use vba or is there an excel function that will do this
 
I have a workbook that is pulling data from one worksheet to another using
the sumif() function and i want to then display this information in another
"summary" worksheet that only displays cells that have a non-zero value.... do
i need to use vba or is there an excel function that will do this
Click to expand...

Galen,

You could link the summary to the data and then apply a filter wherein
you view the non blanks. If the filter doesn't give you the results
you are looking for, then you'll probably need a macro.

Best,

Matthew Herbert
 
Back
Top