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

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

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