Copying data from one work sheet to another as the user enters i

alan - Mar 19, 2015 at 03:11 AM
As the user enters a row of accounting information on shet1 then I want to be able to copy ie distribute the information to one of several worksheets.
So if project code on input in sheet1 is Kan then the line is copied to the next blank row on the Kandy worksheet and of project code is Col then it goes to the next blank line on the Colombo worksheet and so on as the user enters each line

the two spreadsheets dont exactly match sheet1 format so i need to be able to map cols 1-5 to cols 1-5 but col6 & 7 need to be transformed (because outgoing on sheet1 becomes incoming on the other sheets
Any helpplease???