Forum Discussion
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...
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 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
Last try ... hope to help you...see file 🙂
Nikolino
I know I don't know anything (Socrates)
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)
Data / Filters / Special Filters
no duplicates
now you can adjust whether it is placed in the same place or somewhere else;NikolinoDE thanks but i couldn't find the sheet attached
Data /
no duplicates
now you can adjust whether it is placed in the same place or somewhere else;
