I have two sheets where in one sheet the numbers go up sequentially in a column. in the other sheet i have an adjustable cell where the sequential numbers are entered which provides a sum in a "total" cell. I need that "total" to be added back to the first sheet. so when 1 is entered into the adjustable cell the sum is brought over to the sequential sheet to the corresponding "1". when "2" is entered into the adjustable cell, the new "total" is brought over to the sequential column sheet to the corresponding "2" and so on.. any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
first question - don't even know how to title it
- Thread starter bigtome78
- Start date
Left sheet is sequential from 1:1000 in column A. in column B is the answer to a formula in the right sheet. As the numbers count up in the left sheet, the "sum" in the right sheet changes and I need that "sum" to correspond in column B in the left sheet. If the "1" from the left sheet column A goes into the formula in A1 of the right sheet and "2" is the result (B2), I need the "B2" in the right sheet to be in B2 in the left sheet.
I think this is a data table scenario, just can't seem to sort it out.
Upvote
0
Similar threads
- Question
