View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Naeem Naeem is offline
external usenet poster
 
Posts: 13
Default How to pick up data which meets certain requirement

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