Across the top in Row 1, I have dates from Column C (9/15) to Column AN
(10/15). In Column B I have the 'current percent complete' that is linked
back to worksheets that are updated by each one of the 15 manufacturing
teams. Since column B is always current, I can go to the sheet each day and
just key in the 15 percentages in the column for 'today', but I was sick on
Friday and the functional managers went nuts. Go figure. So - what I'm trying
to do, is make it to where anyone can open the worksheet and have the values
from Column B auto-populated into the column that is = to today().

I'm going to try the macro that you suggested - but even if it doesn't work,
I appreciate very much your response. FSt1 and Dave - thank you, too!

Regards,
John




--
Cool


"ShaneDevenshire" wrote:

Hi,

Depending on how you are plotting your data, a formula in the cell may be a
problem even if it return "". The code to do what you want look like

Sub Update()
If Sheet1.[A5] = Date Then
[B10] = 25
[C10] = 50
End If
End Sub

However, I suspect you're not telling us everything so the macro above is of
limited or no use.

--
Thanks,
Shane Devenshire


"Brenner" wrote:

How do I reference other cells in the "Value If True" and "Value If False"?

Example: Formula is in A10 and it reads like this...
=IF(A5=TODAY(),B10=25,C10=50)

So - if A5 is equal to Today(), then the # 25 will be placed in B10. If the
A5 is not equal to Today(), then the # 50 will be placed in C10.

When I'm typing in the formula - it seems that all the cells are referenced
as I type them in both the 'value_if_true' spot and the 'value_if_false' spot
in the formula - but the result is ALWAYS -- A5 = FALSE. That's all I ever
get. False in the original cell.

Kindest Regards,
John Brenner