I want to get all student names in report sheet from all classes sheets but sorted alphabetically(A to Z) and without duplicates using a code or an equation if possible
I want to get all student names in report sheet from all classes sheets but sorted alphabetically(A to Z) and without duplicates using a code or an equation if possible
Hi Leprince..
Roll no 1 have 5 different names in all sheets..
so in your consolidated sheet which name should be there from 5 different names ?
Can u share sample expected output
Regards
Parth
I appreciate your feedback. Hit * if u Like.
Rules - http://www.excelforum.com/forum-rule...rum-rules.html
I added the results by using pivotable from consolidation multiple ranges.But I want to do the job using vba code.
find the attachment
Last edited by leprince2007; 08-04-2016 at 09:55 AM.
Up...........Up......UP
Up...........Up......UP
Try this code
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 08-08-2016 at 12:40 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks