close

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) amp; Sheet2(E33). Is
there a way to have the answers for all the rows on Sheet1 appear on
Sheet1(D1100)?

Thank you,
Emmett--
Emmett423
------------------------------------------------------------------------
Emmett423's Profile: www.excelforum.com/member.php...oamp;userid=32958
View this thread: www.excelforum.com/showthread...hreadid=527853
make D1 on sheet1 equal to E22 on sheet2

formula in D1 is =sheet2!e32--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=527853
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: www.excelforum.com/member.php...oamp;userid=32958
View this thread: www.excelforum.com/showthread...hreadid=527853

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()