estatefinds
03-14-2016, 03:58 PM
Need this to be in VBA please!
The values in the columns GHIJK are the values smallest to greatest. the values in the columns MNOPQ are replaced with numbers that found in column W. so for example the the numbers in columns G11:K11 are
1 2 3 4 5. The number 1,on G11 , the first number in the combination is replaced with the number 1 and placed in column M11 because based on the key chart to the right in columns W11 to AB100 shows that the value from the pool of values which are the numbers used to make up the combinations GHIJK are lined up with numbers in column W.
so in GHIJK you have 1 2 3 4 5 in the columns MNOPQ you have the numbers 1 1 10 6 3 reason being the 1 in the pool of numbers is on the same row as the number 1 in column W which in column W is labeled 1, the 2 in the pool is on the same row in column W labeled 1 the 3 in the pool is on the same row as the 10 in column W the 4 in the pool is on the same row as the row labeled 6 and the 5 in the pool is on the same row labeled 3.
I need a VBA macro to do this as the pool always changes and the formula function is limited as you will see if you look on the attachment in columns MNOPQ at row 2604; there are zeros.
A VBA macro is best for this worksheet.
Thank you!
The values in the columns GHIJK are the values smallest to greatest. the values in the columns MNOPQ are replaced with numbers that found in column W. so for example the the numbers in columns G11:K11 are
1 2 3 4 5. The number 1,on G11 , the first number in the combination is replaced with the number 1 and placed in column M11 because based on the key chart to the right in columns W11 to AB100 shows that the value from the pool of values which are the numbers used to make up the combinations GHIJK are lined up with numbers in column W.
so in GHIJK you have 1 2 3 4 5 in the columns MNOPQ you have the numbers 1 1 10 6 3 reason being the 1 in the pool of numbers is on the same row as the number 1 in column W which in column W is labeled 1, the 2 in the pool is on the same row in column W labeled 1 the 3 in the pool is on the same row as the 10 in column W the 4 in the pool is on the same row as the row labeled 6 and the 5 in the pool is on the same row labeled 3.
I need a VBA macro to do this as the pool always changes and the formula function is limited as you will see if you look on the attachment in columns MNOPQ at row 2604; there are zeros.
A VBA macro is best for this worksheet.
Thank you!