Dear Pan,
Warm greetings from me!
First of all I apologize here once again for not understanding your code well before. It’s very close to my requirement now. Only few revisions have to do to make it complete.
Revisions require:
Do not hide any sheet, row because I have to enter another data in it. Here I have not entered that data.
Do not color any cells
Do not protect any sheet because I have another code in other macro to protect the workbook with password
No need to enter receipt no. manually. Now here I have inserted the code for automatic receipt no in a8 lc sheet after hitting enter key on a8. Please try to avoide this step to hit enter on a8. It should change automatically after hitting enter key on g7 lc sheet only to speed up the work.
Cell g4 is filled with another data and here it is blank. So do not use it in this programme.
No need of pop up message to record the receipt no and date-time. It should be automatic and must without the permission of user.
There is not a word ‘receipt no’ in my original workbook. Only the receipt no. is in cell a8 lc sheet. I have mentioned here it for you to that there is a receipt no. in cell a8 lc sheet. So avoide referencing cell a7 in the code.
After entering the register no. in cell g7 lc sheet there is no need to move the cursor on a8 for receipt no. After entering register no. in cell g7 lc sheet and hitting enter key on it (g7 lc sheet) the receipt no. a8 lc sheet should change automatically and cursor should be on g7 only.
Do not hide variable sheet. I will hide it later.
Do not limit the register number length because it increasing day by day endlessly.
Please do the above mentioned revisions in the updated workbook attach here only to avoide any confusion from my end.
Today I’m very glad to receive a positive solution close to my requirement from you. Hope to receive a final updated workbook today positively.
I’m feeling very guilty for not understanding the code before and prolonging it long.
Thank you and have a good evening.
Bookmarks