Copying to another sheet

Giganews Newsgroups
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.

Thanks

Replies