Variable sheet and Formula Sheet

E

Emmett423

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
 
E

Emmett423

Is there a quick way to put all three variables for about 50 rows int
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top