Variable sheet and Formula Sheet
 

Sheet 1 has 3 columns of data(variables), Sheet 2 contains a formula
needing three inputs. Sheet1(A1) needs to go into Sheet2(C13),
Sheet1(B1) needs to go into Sheet2(D22), and Sheet1(C1) needs to go
into Sheet2(E26). The answers appear on Sheet2(E32) & Sheet2(E33). Is
there a way to have the answers for all the rows on Sheet1 appear on
Sheet1(D1:D100)?

Thank you,
Emmett


--
Emmett423
------------------------------------------------------------------------
Emmett423's Profile: http://www.excelforum.com/member.php...o&userid=32958
View this thread: http://www.excelforum.com/showthread...hreadid=527853

Variable sheet and Formula Sheet
 

make D1 on sheet1 equal to E22 on sheet2

formula in D1 is =sheet2!e32


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=527853

Variable sheet and Formula Sheet
 

Is there a quick way to put all three variables for about 50 rows into
the same formula or function on Sheet2?

Row1:Row50 each have 3 different variables.

Each row needs to run the formula for itself and get its own answers.

It seems like I might need VBA to achieve this.


--
Emmett423
------------------------------------------------------------------------
Emmett423's Profile: http://www.excelforum.com/member.php...o&userid=32958
View this thread: http://www.excelforum.com/showthread...hreadid=527853