I have a spreadsheet where i input numerical data in I2 and I3 (SHEET 2)where after if computes in a dozen cells gives me (3) answers in K9, L9 and M9(ALSO ON SHEET 2). On sheet 1 I put answers to the same (3) cells from sheet 2 dozens of times with different variables. Is there anyway to just input my numerical value in Sheet 1 (A2 and B2) and have it automatically calculate what my answers will be as if i entered them directly on sheet 2 (Answers would be K9, L9 and M9) Just trying to save some back and forth action.
BELOW IS SHEET 2
<tbody>
</tbody>
ON A DIFFERENT SHEET IN THE SAME WORKBOOK
BELOW IS SHEET 1
<tbody>
</tbody>
I would like Sheet 1 to auto-fill (D thru F)if i put in the info in A1 and B1
BELOW IS SHEET 2
A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | DATA | DATA | DATA | DATA | DATA | DATA | DATA | ||||||
2 | DATA | DATA | DATA | DATA | DATA | DATA | DATA | MIN/SZ | 20 | ||||
3 | DATA | DATA | DATA | DATA | DATA | DATA | DATA | MAX/SZ | 48 | ||||
4 | DATA | DATA | DATA | DATA | DATA | DATA | DATA | ||||||
5 | DATA | DATA | DATA | DATA | DATA | DATA | DATA | ||||||
6 | DATA | DATA | DATA | DATA | DATA | DATA | DATA | ||||||
7 | DATA | DATA | DATA | DATA | DATA | DATA | DATA | ||||||
8 | # | $ | HR | ||||||||||
9 | 21.95 | 13.26 | 0.39 | ||||||||||
10 |
<tbody>
</tbody>
ON A DIFFERENT SHEET IN THE SAME WORKBOOK
BELOW IS SHEET 1
A | B | C | D | E | F | G | H | ||||||||||||||||||
1 | MIN/SZ | MAX/SZ | # | $ | HR | ||||||||||||||||||||
2 | 20 | 48 | 21.95 | 13.26 | 0.39 | ||||||||||||||||||||
3 | |||||||||||||||||||||||||
4 | |||||||||||||||||||||||||
5 | |||||||||||||||||||||||||
6 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
8 | |||||||||||||||||||||||||
9 | |||||||||||||||||||||||||
<tbody>
</tbody>
I would like Sheet 1 to auto-fill (D thru F)if i put in the info in A1 and B1