Hello and thanks in advance for the help,
So from a userform, I have 27 fields which are entered and copied to a seperate workbook. This part I have working fine. The code I am trying to develope is in the "Host" workbook/worksheet. I have developed code to sort and remove duplicate lines of data by the time that they were entered/transfered to the "Host" and by their unique indicator. The problem is that if on the first entry the user fills out all 27 fields i will have one complete sortable row, if they come back later and just update one of the fields and leave the rest blank, it wipes out the previous and correct entry. This sorta ruins the purpose (and fun) of having a userform in the first place. I still want the "Host" to sort out and remove duplicates, but how can i get it to either "fill in" or "not fill in" based upon the most recent entry having the most correct information. For example if the start date is filled out in the userform on the first entry, and then a week later they need to update more fields on the userform, they should be able to skip (leave blank) the start date and just fill in the field required. I dont want that blank to over ride the previous weeks entry, and the two entries should be "merged" to create just one line based upon their unique indicator.
This is what I have so far
Maybe the solution is in the transfer FROM the user form??
Anyhow, thanks a ton
Bookmarks