![]() |
how do I filter data and put in a new worksheet
I have a worksheet of outstanding invoices. I have a column that calculates
how old the invoice is (i.e. 30, 60, 90 days overdue). I want to create on another worksheet, three lists. One that lists all the invoices that are 90 days overdue, one that lists all the invoices that are 60 days overdue, etc. I'm not sure of the specific formula I should be using to review a list of data and only copy the rows that show a specific text in one of the cells. |
All times are GMT +1. The time now is 04:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com