Search for Non-Duplicate Values Then Copy Row to Another Sheet

[Stonesteel15]

Greetings!

I am currently working in an automation with auto query data from a website. Now I have to make a vbcode automation that will search the entire column and then search for a non-duplicate/non-repeating values that were queried from website. let's say it's a new data inserted to the website. In our work, we have to query a what we called SR (Service Report) Numbers every hour, because there is a new SR being generated in the website hourly. What I want to do is isolate the new data being queried hourly and then copy it to the next sheet. [Why I can't attach a file? ]

[Fotis1991]

Hi

With your Data, in Column A, try this.

=IF(COUNTIF($A$1:$A$1000;A1)=1;"NON DUPLICATE";"DUPLICATE")

Change semi=colons, to gomma, if you have to do this.

[Stonesteel15]

hi Fotis1991, is there any vba code that when I click the command button, it will execute the isolation of non-duplicate values and copy it to the other sheet?

[Stonesteel15]

here is the workbook sample,

SR Worklist.xlsx

in sheet "Group SR" are the data extracted from a web at time of 11AM and 12PM, in query at 11AM those highlighted in red are still not duplicate since it was the first query, therefore I can copy it to the next sheet named "Worklist", then in query at 12PM, another re query will be done, therefore since it will query again the whole table, a duplicate entry will now exist, thus highlighting duplicates in red, but at the end of the column are data that are not highlighted in red, which means new entry and still not duplicated, now what I try to do is copy this new unique entry and put it in the sheet "Worklist". In short, copy all new unique entries for every query that I will be done hourly. A vbcode that will do this in one click of command button.

[nilem]

try this

Please Login or Register  to view this content.

[Stonesteel15]

Wow, the code works! Thank you very much nilem! I thought I won't be able to resolve this. I'm so glad that one part of my automation is complete.

[Stonesteel15]

Can I ask another question? I want to put the command button in the sheet "Worklist" where the new entries will be placed, what should i change in the code?

SR Worklist.xlsm

[nilem]

Please Login or Register  to view this content.

[Stonesteel15]

thanks for the code, is there a way to disable the filter and clear the criterias without having the row1 deleted?, I have some important information stored in row1 like headers and other values referencing the userform to. I just want to retain all the values in cells of row1. thank you.