statement

[tghcogo]

I have a number of ongoing monthly worksheets with columns showing customers, invoice nos, date, value, VAT etc. and a final column where I enter the date paid. I sometimes want to produce a statement for a customer showing the unpaid invoices, and use the find/worksheet/values - find all method. At this point it gets fiddly having to switch back and forth between active windows, to copy individual rows to a separate worksheet.

Is there an easier way to do this?

[Don Guillett]

Could you use data>filter>autofilter>custom?

--
Don Guillett
SalesAid Software
[email protected]
"tghcogo" <[email protected]> wrote in
message news:[email protected]...
>
> I have a number of ongoing monthly worksheets with columns showing
> customers, invoice nos, date, value, VAT etc. and a final column where
> I enter the date paid. I sometimes want to produce a statement for a
> customer showing the unpaid invoices, and use the find/worksheet/values
> - find all method. At this point it gets fiddly having to switch back
> and forth between active windows, to copy individual rows to a separate
> worksheet.
>
> Is there an easier way to do this?
>
>
> --
> tghcogo
> ------------------------------------------------------------------------
> tghcogo's Profile:
> http://www.excelforum.com/member.php...o&userid=10494
> View this thread: http://www.excelforum.com/showthread...hreadid=513664
>