Copying to another sheet

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

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
 
This will only work for one line but i have multiple lines
so i will need to run a macro or something...

What i need is like a lookup table but works for multiple
lines as i will have a number of lines on the purchase
account and i want them all to copy to the relevant
account (bank) with the same details as on the purchase
account.

Thanks
 
Back
Top