Thanks Dan I understand what you have done ... only trouble is, that you would need to set up a new secondary spreadsheet for every split transaction.
What I have done, in the end, is to simply type the several lines of detail into the cell concerned, using Ctrl+Enter to get a new line within the cell for each sub-item. row height adjusts automatically and I have gone into Format>Cells to make sure it looks neat and tidy Kind regards, James ----- Original Message ----- From: Joe Conner To: [email protected] ; [EMAIL PROTECTED] Sent: Sunday, April 15, 2007 2:02 AM Subject: Re: [users] Calc question.? Copied to James as I cannot tell if he is subscribed. While a database would be a much better solution, if you insist upon using CALC you can use multiple worksheets to accomplish what you have asked for. I am attaching a Calc spreadsheet with the illustration you provided below. It is called JamesTest.ods to illustrate what can be done. Check out the formula in Sheet1 cell C2, and then look at Sheet2 to see the reference. Joe Conner, Poulsbo, WA USA James Elliott wrote: I am a long time list member but have recently installed a satellite dish, so this address might come up as not belonging to the list. I have a cash book which is a Calc spreadsheet (latest version), so it has the usual columns: DATE TRANSACTION-DETAIL AMOUNT BALANCE Sometimes you will have one bank deposit transaction which includes payments from several customers: DATE TRANSACTION AMOUNT 13/4/06 Receipts $297.50 but this $297.50 might constitute several payments, like this INV 1233 Smith $100.00 INV 1250 Jones $ 76.00 INV 1413 Brown $121.50 What I want to do is to insert a 5 row, 4 column spreadsheet inside the transaction detail cell of my main spreadsheet so that I can split the transaction total into its component parts. That way, if I want to know if Mr Jones has paid I can simply search for "INV 1250", or "Jones", or "76.00" Can this be done? Kind regards, James --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ------------------------------------------------------------------------------ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.4.0/760 - Release Date: 13/04/2007 8:04 PM
