Macro Filter

  • Thread starter Thread starter Blue
  • Start date Start date
B

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?
 
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.
 
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!
 
Back
Top