Hello everybody
I have a worksheet with a column "ItemCode" and a few more associated columns. The worksheet contains multiple records for each ItemCode.
My concern is to copy those records to another worksheet with only the first occurance of each ItemCode (eliminating records with duplicate ItemCodes).
Any help apprciated.
Advanced Filter has both CopyToDifferentLocation and UniqueOnly options.
The ListRange, CriteriaRange and CopyTo ranges can all be on different sheets, but (from the keyboard) the CopyTo sheet should be active when the AdvancedFilter button is pushed.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks for the prompt. But, I want to do it Programmatically.
A programatic solution will be appreciated.
Start by doing what Mike suggests whilst recording a macro. The resulting code can then be tidied upOriginally Posted by Rabi
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks