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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dynamic worksheet reference 1
looking for a function that will populate opening a worksheet or t 2
Excel VBA 1
Counting results of a formula 9
Referencing a cell in other worksheet that is using autofit row he 3
How do you set a cell to increase numerical sequence? 2
linking a range of cells (=) to another range 4
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0

Back
Top