Linking Data from one sheet to another sheet

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
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.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
Are the values to be created/dealt with, for a particular purpose?
Financial, Numerology, etc ???

(y)
 

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
Yes, number randomness analysis

Also, I would guess that the sample range of 8 and 22 would have to be selected in the program sheet.
example
c6=8
d6=22
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top