Macro to fill Column B with system date when Column A changes

Hi All,

Can any one help me in how to update a cell column B with system date when a cell in column A changes.

I have written a VBA code which does the same, but the tricky part was when i do a fill-down or drag on a cell in column A it reflects only the top cell in column B with the system date but not all the cell that were changed in column A

Regards,
Mahi

I'd guess you would need a helper column with the "current" values of column A, say in column C. then use something like:

Please Login or Register  to view this content.