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

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

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