P
Paulie
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
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