Forum Discussion

Deleted's avatar
Deleted
Jul 30, 2020

Calculating (4, Threads): 1%

Hi Experts,   I have a Sheet1 which has 3 Columns (Column A with Product Type, Column B with Product ID, Column C with Product Name) and 1000 rows with data in it. I am using below formula to remov...
Excel
Excel for web
Formulas and Functions
Macros and VBA
  • NikolinoDE's avatar
    NikolinoDE
    Jul 31, 2020

    Deleted 

    Everything simplified here with VBA ... press the button and everything is copied over ... everything? ... almost, duplicate entries not :-).

    If you liked my solution, please mark it as the correct answer ... if possible with a like so that everyone else can be informed. If you did not like my answer, please ignore it and of course I apologize that I took your time.

    Wish you a nice day and for further questions about your topic, I am at your disposal.

    Nikolino
    I know I don't know anything (Socrates)

     

Deleted's avatar
Deleted

NikolinoDE Thanks for your help and providing solution in the sheet.

 

i hv added your sheet attached with my actual data.

 

When i click on button i want to show output in separate tab as per product name with no duplicate records.

 

Can u pls modify your code and send me updated sheet again.

 

Thanks in advance.

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jul 30, 2020

Deleted 

Voici une solution avec la copie..

Si cela correspond à vos idées en tant que solution, veuillez la marquer comme la bonne réponse, afin que les autres informés puissent être informés ... mieux avec un like.:-)

Si vous n’avez pas aimé la solution proposée, veuillez donner un bref commentaire.


Nikolino
Je sais que je ne sais rien (Socrate)

  • Deleted's avatar
    Deleted
    Jul 30, 2020

    NikolinoDE thanks this is not giving result as expected.

     

    Actually i want to show result in separate Product Name Sheet Tab created (Grociery, Veggie, Fruits).

     

    When i click on button the code should read and analyse my original data and should filter only unique data excluding duplicate and copy the same in respective product sheet as per product name.

     

    The original data should remain like that only and it should not get deleted as i will keep on adding data in the original sheet.

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Jul 30, 2020
      .RemoveDuplicates
    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Jul 30, 2020

      Deleted 

       

      Last try ... hope to help you...see file 🙂

       

      Nikolino
      I know I don't know anything (Socrates)

      • Deleted's avatar
        Deleted
        Jul 30, 2020

        NikolinoDE Nope.. this is not correct.

         

        anyways thanks.. this is not expected result.

         

        i want to filter Tabelle1 data and copy all the records without duplicate in separate tab sheet filter by Product Name (Groceries, Veggie, Fruits)

Resources