Hi

Is there a way to pick up data from a sheet based on 3 different
criterias at 3 different places?


I have sheet 1 which has all the customer data with invoices and days
outstanding. I would like to pick up the date in three different ways
on 3 different sheet (may be one but in 3 different locations). For
example <31 Days, <30<60...etc.


Is there a way I can do it which do not make my file size go big.?


I have formula upto 3000 rows.


I hope I was able to explained my question.


Thanks,
Naeem