|Subject:||Copying to another sheet|
|Posted by:||Edgar (edgarthoemm…@s-h-g.co.uk)|
|Date:||Thu, 9 Oct 2003|
Is there any way of when i enter a value in one sheet for
it to automatically paste the value on to another sheet.
What i am doing is entering a invoice on the purchase
sheet where i choose from a drop down menu what account it
is coming from ie (chq, petty cash, bank, etc) and i would
like it to automatically copy the line accross to the
relevant sheet but obviously to change the line from a
debit to a credit as well.