
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Hi, I need to give the users of my data a spreadsheet with the option of 'choosing' which items are relevant to their needs. I need them to make a preference choice between all the possible combinations, using VLOOKUP. Where my problem is though is as follows. I have a list of unique part numbers in a column. I need a macro to prepare a list that I can do some further comparitive work on. My list looks something like this. Column A 00237 00243 00251 00377 I need to be able to cross reference each part number with each of the others, generating a list which wil look like the following: Column A Column B 00237 00243 00237 00251 00237 00377 00243 00251 00243 00377 00251 00377 In essence, I need to create a rows that have every possible combination of part numbers. If I can get to the above result, I can handle the VLOOKUP part of the equation. Any help greatly appreciated
| <-- __Chronological__ --> | <-- __Thread__ --> |