G
Guest
I am looking for a simple way to track when pricing on a worksheet has been
updated. I would like to have one cell contain the update date and if
possible, the username. Any cell on the worksheet may be changed and all I
want is the cell updated on the worksheet if something on it changes. Then
that date would remain until something else on the worksheet changes.
Formula or macro doesn't matter, but would prefer one that keeps file size
smaller. I will have several worksheets in a workbook, and each sheet will
have its own date.
Separately, I would also like to have the master worksheet in the file show
a "special pricing" message if the pricing from another worksheet is changed
after the file has been opened.
thanks, Pam
updated. I would like to have one cell contain the update date and if
possible, the username. Any cell on the worksheet may be changed and all I
want is the cell updated on the worksheet if something on it changes. Then
that date would remain until something else on the worksheet changes.
Formula or macro doesn't matter, but would prefer one that keeps file size
smaller. I will have several worksheets in a workbook, and each sheet will
have its own date.
Separately, I would also like to have the master worksheet in the file show
a "special pricing" message if the pricing from another worksheet is changed
after the file has been opened.
thanks, Pam