Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed
Hi Naeem
If you filter the data (select column headers, then DataFilter) 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 "Naeem" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
VBA help needed please | Excel Programming | |||
Help needed | Excel Discussion (Misc queries) | |||
help needed | Excel Worksheet Functions | |||
Help needed... | Excel Discussion (Misc queries) |