Sample Generator

Hi, what I need is vba code that will work in excel that would generate random data sample of x which the user defines i.e 10, and where the user defines the input data but I also want these values to be unique. Here's is a sample of data i.e Col 1 Col2 Col3 Col4 Col5 0123 Issue O/S O/SIssue ResIssue Results 0124 Issue Asg GenIssue ProgIssue Progressed 0125 Issue O/S O/SIssue Issue O/S O/SIssue 0126 Issue Asg GenIssue Issue Asg GenIssue So, Col1 would have unique values eachtime but Col2 and Col4 would have same sort of values and same for Col3 and Col5. Therefore what I need is to pick a unique value from Col1 where either the data in Col2 doesn't match Col4 or where Col3 doesn't match Col5. In the above case it would pick 0123 and 0124. Also the data number of rows would vary from one sheet to another so maybe when the user select the input data it puts it into an array and then randomly picks unique values from that sheet. Any Suggestions? Thanks ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Vba