I have a "data" sheet with a list of 3 digit combinations in columns I, J and K
(eg. I1:k1 = 359 and so on), in the M column I have calculated the sum value of the 3 cells, ( eg. 359= 3+5+9=17). My range of sums are 0 through 27.
I want to go to a "program" sheet within the same workbook to be able to select any range of sums between 0 and 27, (eg. 8 begin range and 22 ending range), this will then populate the program sheet cells in columns B, C and D, starting with row 30, with only the I:K combinations which have sums between 8 and 22 in the M column on the data sheet.
Example: in the data sheet I1:k1 = 359, which equals a sum of 17, This is between the selected range of sums on the program sheet, therefore, 3,5,9 gets added to the program sheet in B30:D30.
The sum range is only one of several other conditions, I will create within the program sheet to pull data from the data sheet.
(eg. I1:k1 = 359 and so on), in the M column I have calculated the sum value of the 3 cells, ( eg. 359= 3+5+9=17). My range of sums are 0 through 27.
I want to go to a "program" sheet within the same workbook to be able to select any range of sums between 0 and 27, (eg. 8 begin range and 22 ending range), this will then populate the program sheet cells in columns B, C and D, starting with row 30, with only the I:K combinations which have sums between 8 and 22 in the M column on the data sheet.
Example: in the data sheet I1:k1 = 359, which equals a sum of 17, This is between the selected range of sums on the program sheet, therefore, 3,5,9 gets added to the program sheet in B30:D30.
The sum range is only one of several other conditions, I will create within the program sheet to pull data from the data sheet.