Hello,
I know that this should be simple - but I'm not sure how to get the
results I want.
I want the unique record to be from one column - but if the data in the
next column is not unique - I still want it to only consider the
uniqueness of the first column.
For instance - if I want select only one vendor - but the column next to
the vendor has a different PO number, I don't want it to show me all the
records for the particular vendor - I only want it to show me the
information on the one vendor - without bringing along the instance of
the vendor when it has a different PO.
Any help would be appreciated. Following is a lame sample.
Sub Try()
Dim myVariable
myVariable = InputBox("Choose your contract", "contract", "Mentor")
Range("d2").Value = myVariable
Columns("A:A").Select
Range("A1:b7").AdvancedFilter Action:=xlFilterCopy,
CriteriaRange:=Range( _
"D1:D2"), CopyToRange:=Range("F1:g1"), Unique:=True
End Sub
Bookmarks