software

I have a formula in one cell, that gives me different results for different
entries. I would like to store this results in an other place (other range of
cells) so that in the end to have, for example, the last 10 results of this
formula. Is this possible? I am a beginner. Thank you.


each time you use the formula to produce an answer, you must paste that
answer as a value into a list....... If your list is next to the
numbers 1,2,3etc
............A.........B
1..........1......15.43
2..........2.......7.89
3..........3.......12.1

Then you could pick out the last 10 results using offset and match--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=531486You would probably need to use a macro or be very clever in using intentional
circular references.

You can't have 10 instances of the formula and let the user specify 10
separate inputs?

--
Regards,
Tom Ogilvy
quot;Deliaquot; wrote:

gt; I have a formula in one cell, that gives me different results for different
gt; entries. I would like to store this results in an other place (other range of
gt; cells) so that in the end to have, for example, the last 10 results of this
gt; formula. Is this possible? I am a beginner. Thank you.

Thank you Tom Ogilvy and Robert111.
Tom I feel clever but I can't use intentional circular references... not
yet... :-)
This formula is it self a kind of result from a range of cells (6x7)
Robert111: I've thought of that, but as I said, I am a beginner... How to
paste the answers as values automatically?

quot;robert111quot; wrote:

gt;
gt; each time you use the formula to produce an answer, you must paste that
gt; answer as a value into a list....... If your list is next to the
gt; numbers 1,2,3etc
gt; ............A.........B
gt; 1..........1......15.43
gt; 2..........2.......7.89
gt; 3..........3.......12.1
gt;
gt; Then you could pick out the last 10 results using offset and match
gt;
gt;
gt; --
gt; robert111
gt; ------------------------------------------------------------------------
gt; robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
gt; View this thread: www.excelforum.com/showthread...hreadid=531486
gt;
gt;


you can not paste the answer from a formula automatically....

butyou can write a simple macro that picks up that value, goes to the yop
of your list, goes to the bottom of the list, goes down one cell, and
then pastes, special, values.

You need to set the macro recorder to relative references

Say the top cell of your list is named quot;startquot;

the macro would go to start, ie F5, start
go to the bottom of the list ie Control key and down arrow together
go down one more cell ie down arrow
finally edit paste special values

You could draw a box and position near your original formula and attach
the macro to it, so one click and your latest value is archived.--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=531486Thank you , I will try.
I wish you all a nice day.
Delia

quot;robert111quot; wrote:

gt;
gt; you can not paste the answer from a formula automatically....
gt;
gt; but
gt;
gt;
gt; you can write a simple macro that picks up that value, goes to the yop
gt; of your list, goes to the bottom of the list, goes down one cell, and
gt; then pastes, special, values.
gt;
gt; You need to set the macro recorder to relative references
gt;
gt; Say the top cell of your list is named quot;startquot;
gt;
gt; the macro would go to start, ie F5, start
gt; go to the bottom of the list ie Control key and down arrow together
gt; go down one more cell ie down arrow
gt; finally edit paste special values
gt;
gt; You could draw a box and position near your original formula and attach
gt; the macro to it, so one click and your latest value is archived.
gt;
gt;
gt; --
gt; robert111
gt; ------------------------------------------------------------------------
gt; robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
gt; View this thread: www.excelforum.com/showthread...hreadid=531486
gt;
gt;

Even a macro isn't going to function automatically. You would have to
trigger it by tying it to the appropriate event. Chip Pearson has an
introduction to events at

www.cpearson.com/excel/events.htm

If you want to pick up the next available cell in a range

set rng = Range(quot;M1:M10quot;)
idx = application.countA(rng)
if idx lt;gt; 10 then
rng(idx 1).Value = range(quot;B9quot;)
else
' range if full - what do you want to do
end if

--
Regards,
Tom Ogilvy
quot;Deliaquot; wrote:

gt; Thank you , I will try.
gt; I wish you all a nice day.
gt; Delia
gt;
gt; quot;robert111quot; wrote:
gt;
gt; gt;
gt; gt; you can not paste the answer from a formula automatically....
gt; gt;
gt; gt; but
gt; gt;
gt; gt;
gt; gt; you can write a simple macro that picks up that value, goes to the yop
gt; gt; of your list, goes to the bottom of the list, goes down one cell, and
gt; gt; then pastes, special, values.
gt; gt;
gt; gt; You need to set the macro recorder to relative references
gt; gt;
gt; gt; Say the top cell of your list is named quot;startquot;
gt; gt;
gt; gt; the macro would go to start, ie F5, start
gt; gt; go to the bottom of the list ie Control key and down arrow together
gt; gt; go down one more cell ie down arrow
gt; gt; finally edit paste special values
gt; gt;
gt; gt; You could draw a box and position near your original formula and attach
gt; gt; the macro to it, so one click and your latest value is archived.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; robert111
gt; gt; ------------------------------------------------------------------------
gt; gt; robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=531486
gt; gt;
gt; gt;