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 |
All times are GMT +1. The time now is 08:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com