pls teach me how to autotransfer data from "sheet 1" to other sheet "IAS2901" "IAS2902"... follow by the code in "sheet 1". this sheet1 data will update from time to time, would data autotransfer everytime i key in.
The link to the sample file in the above link still works so have a look at it also and see what you think. Click on the "UPDATE" button to see how it works. You'll notice that the data for each individual mentioned in Column C is transferred to the individual's sheet.
If its what you would like to do with your own file, then let us know and we can help you adapt it to your workbook. Experiment with it yourself first.