the normal method to change a formula into a value is to copy and paste
special values.
you can have a formula in k3 such as

=if(k$2=$a$2,$b3,"")

where k2 is the date on which you want to record the data
a2 is today's date
b3 is the number in your first table that you want to copy

you can extend this formula across the page

at the end of each "day" you can highlight the second table column
that needs to be changed into values <right click<copy<right click<
select paste special<select paste values.

this last routine could be done with a macro, but you would somehow
need to find the right column first.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=468022