Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
statement
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions |