Hi! Please I'm a newbie to excel vba, so there's this report card I'm trying to do for my school, so if I put a reg number in a cell the details of the student will display if I press generate, then I can now print it. But I want a vba micro that will be changing the reg no. And generate the details and then print automatically. Please I need help. Thanks.