In the attachment when i enter a voucher number if it is already exist show the message, ALREADY EXIST, otherwise type it
I need macro for this purpose please do the needful.
In the attachment when i enter a voucher number if it is already exist show the message, ALREADY EXIST, otherwise type it
I need macro for this purpose please do the needful.
Hello geniusufo007,
The spaces between your "Payment Vouchers" are inconsistent. I also assume that you copy and paste from a previous "Payment Voucher" to create a new one, every time.
If you keep your spacing always the same, the following Sample Workbook should work for you.
Regards.
Last edited by Winon; 01-04-2019 at 01:47 AM. Reason: text
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Thanks Mr Winon for your effort
You are welcome,geniusufo007,
Glad I could help, and thank you for adding to my Reputation. I appreciate it!
Also thank you for marking this Thread as Solved.
Regards.
Hello geniusufo007,
I was not entirely happy with my solution I had given you, so here is a much better option!
Hope you like it.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks