Macro 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? -- Blue |
Macro Filter
Hi Blue,
If you apply AutoFilter to the worksheet, you should be able to click the dropdown arrow and select P for your ticks and you will only see the Paid, select blanks for the unpaid and select all for both. -- Regards, OssieMac "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? -- Blue |
Macro Filter
That is the thing - i cannot apply the filter as the layout of the
spreadsheet will not allow me. That is why I was wondering if i could do it any other way! -- Blue "OssieMac" wrote: Hi Blue, If you apply AutoFilter to the worksheet, you should be able to click the dropdown arrow and select P for your ticks and you will only see the Paid, select blanks for the unpaid and select all for both. -- Regards, OssieMac "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? -- Blue |
All times are GMT +1. The time now is 02:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com