software

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: www.excelforum.com/member.php...oamp;userid=10494
View this thread: www.excelforum.com/showthread...hreadid=513664Could you use datagt;filtergt;autofiltergt;custom?

--
Don Guillett
SalesAid Software

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