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

http://www.cpearson.com/excel/events.htm

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

set rng = Range("M1:M10")
idx = application.countA(rng)
if idx < 10 then
rng(idx+1).Value = range("B9")
else
' range if full - what do you want to do
end if

--
Regards,
Tom Ogilvy



"Delia" wrote:

Thank you , I will try.
I wish you all a nice day.
Delia

"robert111" wrote:


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

but


you 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 "start"

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: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=531486