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]

Reply via email to