When a cell is Column AK is updated, how do I reflect the date modified in the corresponding cell in BY?
When a cell is Column AK is updated, how do I reflect the date modified in the corresponding cell in BY?
Hi shootingstarz,
You could use event code such as:
![]()
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi-
I'm sorry, for some reason this doesn't seem to be working? This is all a foreign language to me, so I apologize if I'm missing something - would I need to edit any of the above assuming 37 and 77 were the correct columns?
Also, are there any formulas that can be inputted in the actual cells to calculate this as opposed to VBA?
Thank you!!![]()
The code goes in the worksheet module - you could put:
in BY1 etc![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks