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.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Are the values to be created/dealt with, for a particular purpose?
Financial, Numerology, etc ???

(y)
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

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
Back
Top