Can you have a value created by a function replace the function?

  • Thread starter Thread starter xak1222
  • Start date Start date
X

xak1222

I am trying to use functions to create a list of data on one sheet by
replacing the data in a single cell many times on another sheet.

Can this be done using formulas? If not is there another way?
 
Would you like to describe what you want to do in more detail. So far
your description does not seem to tie in with your heading for this
thread.

Pete
 
Oops, I should have used formula not function in the subject line.

I'm trying to create a worksheet where I can enter new data each month in
the same cell and have that data recorded on another sheet each month without
having to do it manually. currently I am trying to use formulas that refer
back to the changing cell and they would work if there is a way to replace
the formula with the ending value.
 
Suppose you want to enter data into A1:A10 of sheet1, and have that
appear in A1:A10 of sheet2, then next time in B1:B10 of sheet2, and so
on. You can put this formula in A1 of sheet2:

=IF(Sheet1!$A1="","",Sheet1!$A1)

and then copy it down to A10. When you have put the data in A1:A10 of
sheet1 for that month, copy A1:A10 of sheet2 into B1:B10, and then fix
the values in A1:A10. To do this, select the range A1:A10, click
<copy>, then Edit | Paste Special | Values (check) | OK then <Esc>.

Each month you enter data into sheet1, then copy the latest column in
sheet2 to the adjacent column and fix the values in the column you
have just copied.

Hope this helps.

Pee
 
Back
Top