Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
Hi,
i have a credit control spreadsheet listing all outstanding invoices. i have a paid column to the RHS of the sheet in which i put a tick (using wingdings 2 font & a capital P) is it possible to have 3 macros in the worksheet to show all paid invoices, all unpaid invoices and all paid & unpaid invoices? note: I cannot use a filter as the spreadsheet will not allow be to do so -- Blue |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
If you can't filter??? then a looping macro to find the cell and copy to the
next available row somewhere else. for each c in range("ddd") if c="whatever" then c.copy etc -- Don Guillett Microsoft MVP Excel SalesAid Software "Blue" wrote in message ... Hi, i have a credit control spreadsheet listing all outstanding invoices. i have a paid column to the RHS of the sheet in which i put a tick (using wingdings 2 font & a capital P) is it possible to have 3 macros in the worksheet to show all paid invoices, all unpaid invoices and all paid & unpaid invoices? note: I cannot use a filter as the spreadsheet will not allow be to do so -- Blue |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
yep, as Don wrote it's possible
but to do that we would need to know exactly how your data looks like On 27 Maj, 14:27, Blue wrote: Hi, i have a credit control spreadsheet listing all outstanding invoices. i have a paid column to the RHS of the sheet in which i put a tick (using wingdings 2 font & a capital P) is it possible to have 3 macros in the worksheet to show all paid invoices, all unpaid invoices and all paid & unpaid invoices? note: I cannot use a filter as the spreadsheet will not allow be to do so -- Blue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |