Hello
Need help in finding out duplicate document number & Vendor with value in multiple sheet. Attached sheet for reference.
rgds
NGP
Hello
Need help in finding out duplicate document number & Vendor with value in multiple sheet. Attached sheet for reference.
rgds
NGP
Give an example of what you want the result to be. Do you want duplicate doc #s and duplicate vendors? Duplicate doc#/vendor pairs? Do you want duplicates within sheets? Between sheets? Between and within?
1. Include a sample workbook with an example of the result you want
2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.
The result should be duplicate doc#/vendor pairs within and between sheets
So, that took longer than I expected. This code should work:![]()
Please Login or Register to view this content.
it is working, thanks
Great. Glad I could helpIf your question has been resolved, please mark this thread as solved and if you feel I've been helpful feel free to give me +Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks