automatically link cells with a certain result to another workshee

  • Thread starter Thread starter Contacts querier
  • Start date Start date
C

Contacts querier

I have a worksheet showing invoice payment results. Can I have only specified
cells from those rows which did not zero out automatically show in another
worksheet?
 
Hi,

The easiest way (manual) is to filter the amount column on numbers greater
then 0 and then copy/paste the resultant cells in another worksheet

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top