Help needed

[Naeem]

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

 

[Bryce]

Hi Naeem

If you filter the data (select column headers, then Data>Filter) you can
filter the data by your days outstanding(<=30,>30&<=60,>60 etc), you can
select all and copy/paste to another sheet, which will only paste unfiltered
data. Do this for each of your 3 criteria.

For file size, this will affectively double up on each record, but if you
pastespecial values, you will save a little, by not duplicating any formulas.
You may want to move these new sheets to a new workbook(s) to keep the
original file size.

If you record this as a macro, you may be able to repeat this easily each
month etc