Using a data table

msheofsky

New Member
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
 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

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
L

msheofsky

New Member
Thank you for your response. I may not have clearly stated what i was looking for. On my spreadsheet I input numbers into I2 and I3. These numbers are computed in my table in mutiple cells and i get an answer in K9, L9 and M9. I was hoping that i would be able to put the same input numbers into sheet 1 and get my spreadsheet to compute them as if i entered them into I2 and I3. See as of right now, I input the numbers(always different) into I2 and I3 (sheet 2) and copy and paste the results all over again into sheet 1 . K9, L9 and M9 are my answers. There is already a formula in this cell that must be there.

L

msheofsky

New Member

Cells A2 and B2 I would input. But i would want the number that i input be calculated as if i inputted them directly into sheet 2 (I2&I3)

L

Legacy 436357

Guest
Okay where do you want these calculations to happen. It is no problem to fill the other cells by inputting A2 and B2 but you don't want calculations in more than one place to avoid circular reference.

msheofsky

New Member
I'm thinking that maybe i cannot do what i want to do. See on sheet 2, all of the cells that say DATA, these cells all have formulas and are calculating me the answer that is on K9 L9 M9. I'm looking to do multiple inputs into the same formula and getting each unique answer. As of right now i input the numerical value and copy/paste the answer in the cell. And then do it again and again.

Replies
1
Views
187
Replies
12
Views
174
Replies
5
Views
224
Replies
0
Views
45
Replies
13
Views
207

1,130,444
Messages
5,642,187
Members
417,259
Latest member
gtacw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back