Hi Pan314,
Thank you for your response. I didn't understand what you have done. Please don't change my workbook so that I will understand the solution more better.

My requirement is that if I enter a register number for example 5 then the program shold hid enter key and go to cell a8 receipt no. and hid enter so that the receipt no. will change automatically. Then the mentioned formula will be created on register sheet range aa:ae infront of entered register number on lc sheet cell g7. Then change the formula into value. It will be a first lc so the output should be in column aa lc1 column. If the student ask for second time lc then I will enter his register no. on lc sheet g7 in this case 5. Then after hiding enter key the a8 cell will be selected. After hiding enter key on it the receipt no. will be change automatically and a formula will be created on sheet register in lc2 column because it is a second lc and so on for each register no. respectively.

Hope this will clear my requirements to you correctly.

Thank you,