Copying data in one file to another file and auto sorting as per indexed cell

[ssbhatban]

Dear Friends

I have two excel files namely master.xls and regno.xls
in master.xls i have 6 digit register no of students in column B, student name in column C, father name in column D
regno.xls also has same columns but will be blank initially. i will type or copy paste from some file the register no of the student in column B. once the cursor moves out of that cell, the program should search the matching register no in master.xls and pull the student name & father name from that file & paste it in column C & column D respectively in the regno.xls file

or even it can do the same operation once all the register nos are entered in regno.xls file & give a command button to search , copy paste from the master.xls

is there any direct method like kutools or some thing like that or some body can help me with vba

thanks in advance

Master.xlsx
	B
5
Sheet1

Regno.xlsx
	G
8
Sheet1

 

[Peter_SSs]

I'm not sure that I can help with your actual problem, but two things that may help you get answers from the forum:

1. Update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
   
   
2. With XL2BB, instead of selecting a blank cell, select the range with the data that you want to show before clicking 'Mini Sheet'.