How to stop doubles from macro ?

[clemlcfc]

Hello, I have this macro that gets values from a sheet and adds for each of the values 3 rows with each time a different value :

Please Login or Register  to view this content.

The problem I have is that if i add a value in the first sheet and rerun the macro, I will get doubles so i tought of adding this but it doesn't work :

Please Login or Register  to view this content.

What do i need to change ? (+Formula in sheet2 is not expanding correctly and I have no clue why ?)

here is the sheet : Sample (1).xlsm

[deadlyduck]

Could you first clear the existing data and then run the code?

[clemlcfc]

I could but I don't want the clear the existing data. I just want to clear the new duplicates

[sintek]

Ideally you would need to add a code snippet that checks to see if value already exists and if not then add it...
Also, no need for concat formula...

Please Login or Register  to view this content.

[clemlcfc]

Thank you ! But the CONCAT formula was there to show that it wouldn't expand. And just something i saw if i add any column they will have automatically "#NA" as a value ?

[sintek]

Like I said...no need for concat formula code above solves that without formula
But...If you really want a formula then this solves...

Please Login or Register  to view this content.

Thanks for rep +