Hi ELegault,
Good evening!

You have to enter the receipt no. manmally because I have not inserted a code for it in the workbook. In my original workbook it changes automatically after hitting enter key on cell a8 lc sheet. I don't want to hide enter key and use alt + f8 to run the macro.

After entering register no. in cell g7 lc sheet the lc is generated then after hitting on a8 lc sheet the receipt no. changes automatically.

Hope this will help you to solve the problem. I'm online so please feel free to ask any doubt to achieve the target.

Thank you,