Macro Filter

[Blue]

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?

 

[OssieMac]

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.

 

[Blue]

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!