footer date

[Cecelia Claybrook]

Is there a way to automate the changing of a date in the
footer only when a change has been made in the data.
e.g. Revised on <date>.

 

[Jim Rech]

Excel doesn't have a feature that changes the footer when a cell is changed.
You could run a macro to make it easier to enter the new footer, e.g.,

ActiveSheet.PageSetup.CenterFooter = _
"Revised on " & Format(Now, "m/d/yyyy")