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)

     

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jul 30, 2020

Deleted 

Here is a small VBA solution.

If you have solved your problem with this solution, please mark it as the correct answer so that others can also get this information.
If this is not what you are looking for, please give us a quick feedback.

 

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

 

  • Deleted's avatar
    Deleted
    Jul 30, 2020

    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.

      • Deleted's avatar
        Deleted
        Jul 30, 2020

        SergeiBaklan thanks but its giving 400 error when i click on button

Resources