formula that puts result in seperate worksheet

  • Thread starter Thread starter Tim Maroni
  • Start date Start date
T

Tim Maroni

Im trying to write a formula in 1 cell that I can enter
numbers to day by day and it will send the result to
another cell in the same workbook but a different
worksheet.

Example: I will put a 2 in F9 worksheet 1(3). Then want
it to carry that 2 into f9 worksheets 1 & 1(2). a day
later I will put a 4 in f9 worksheet 1(3). The result I
need is a 6 to show up in f9 on worksheets 1 & 1(2).

Worksheet 1(3) will be used to enter numbers into a cell
for adding and sending the result to other worksheets in
the same workbook.

Any help I can get would be great.
Thank you, Tim Maroni
 
Tim Maroni said:
Im trying to write a formula in 1 cell that I can enter
numbers to day by day and it will send the result to
another cell in the same workbook but a different
worksheet.

Example: I will put a 2 in F9 worksheet 1(3). Then want
it to carry that 2 into f9 worksheets 1 & 1(2). a day
later I will put a 4 in f9 worksheet 1(3). The result I
need is a 6 to show up in f9 on worksheets 1 & 1(2).

Worksheet 1(3) will be used to enter numbers into a cell
for adding and sending the result to other worksheets in
the same workbook.

Any help I can get would be great.
Thank you, Tim Maroni
Click to expand...

You cannot write a formula that 'sends' (or 'pushes') data elsewhere. A
formula can only 'pull' data. In other words, a formula in a particular cell
can define the result in that cell only.

Also, you will get a circular reference if you try to add new data to the
previous result in a cell (that is, 'accumulate'). Much better to enter your
data into consecutive cells (say Sheet1, A1, A2, A3 and so on) and write a
formula in your other sheets such as =SUM(Sheet1!A:A).
 
Back
Top