Hi,
I have attached a spreadsheet that is a representation of a much larger project I am working on. I need a way to automatically fill out an array (Highlighted in yellow) based on the numbers in column D and row 6. There are 2 sheets in this workbook. You can see that the colors correspond to the cell that will change. For example, in my array, when I change cell F2 to .1, I want the cell in the array (F7) to equal the number that would be spit out in cell I3 (In this case it would be .3). Similarly, when I change the green cell C4 on Sheet2 to 4, the number cell I3 would spit out would be .2, so cell E8 would = .2.
So what I am looking for is a way to fill in my array automatically, without me having to go in and manually type in the numbers each time.
If something on here doesn't make sense ask me, I will be at my computer.
Bookmarks