Hi,

Type in "excel if do nothing" into a search engine and you'll find a bunch
of people asking the same question I have : If a value is already entered
into the cell, then is there a way - using IF - to preserve that value if a
condition is no longer true. Apparently not.

My situation is this:

Column A Column B Column C Column D Column E
Column F
Row
1 Monday Tuesday Wednesday
Thursaday Friday
2 03/23/09 03/24/09 03/25/09
03/26/09 03/27/09
3
4 Items Received 4 5 3
0 10
5 Items Sent 6 3 2
3 12
6 Problems Solved 8 10 1
5 3
7 Problems Created 6 7 0
0 9

Monday I type in the data, then Tuesday, and so on through Friday. Then
next week I update the dates in row 2 (3/23, 3/24 are now 3/30, 3/31 and so
on) and overtype that data with new data as that week progresses. I'd like
to keep a permanent record of last week's data, this weeks data, in fact
every day as I type it in.

Id like to find a way to move each day's data (based on the date) to a
certain row on another worksheet and store it. Each new date will get it's
own row. 3/23's data in column B will be row 1 (4,6,8,6 will be copied and
stored); 3/24's data in column C will be row 2 (5,3,10,7 will be copied and
stored); etc... and once that day is done then that row is no longer touched
by excel.

Hence the problem grabbing that data with an IF function. IF today matches
the date in a certain column, then copy that data to this row and that's
great, but if not then do nothing. The problem is that an IF function will
erase the data by returning "" or zero if the dates no longer match so only
the current date's data will appear in storage.

I need a macro but I've no idea how to search for one. I dont know the
lingo.

Thanks.