Good day
I hope someone might help
You might be thinking that my title is kind of confusing, here it is, I will try to thoroughly explain myself to my best..
You see I have multiple textboxes throwing data in the blank row after last entry, what would I like is having a "duplicate validation" from a selected textbox (which is a column of perfectly unique values), so I only need the duplicate validation there.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello and Good Day alansidman
First of all thanks for your time reading and trying to help me
below is the form I am working into,, it has two sets of database to separate two kinds of people I have to manage..
Let us focus on the SET2 Form.. I need a duplicate validation on column SN in the database (input by textbox_serial)..
For example "SN1" is in the database,, user had "SN1" input again, upon exit on the textbox_serial, a Msgbox can pop
And range would be determined by the number of inputs..
And let me know ur comments on the interface of the form.. (except the design) hehehe
Thanks in advance!!
Good day again
Hello, I have a similar question.
I'm exporting customer data from one application to another. i need to know how to remove duplicate entries based on duplication in one row.
here's an example. I'd like to use from Column A and remove all the duplicate data in rows 2-16 and 19-36.
Is there a simple way to do this with a .CSV file?
@Jerry.Barrax
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks