Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Timestamp cell to left after update
For every row when cell C<whatever is updated I need coresponding cell
D<whatever to update with a date time stamp until such a time that particular cell C is updated again. Been all over the place looking at macros worksheet functions etc. and nothing quite matches what I need. Currently I am using Ctrl-Shift-; followed by Ctrl-; to quickly enter this, but there has to be a way where I do not have to enter it all. Thanks in advance |
#2
|
|||
|
|||
Hi
see: http://www.mcgimpsey.com/excel/timestamp.html -- Regards Frank Kabel Frankfurt, Germany "Tahlmorrah" schrieb im Newsbeitrag ... For every row when cell C<whatever is updated I need coresponding cell D<whatever to update with a date time stamp until such a time that particular cell C is updated again. Been all over the place looking at macros worksheet functions etc. and nothing quite matches what I need. Currently I am using Ctrl-Shift-; followed by Ctrl-; to quickly enter this, but there has to be a way where I do not have to enter it all. Thanks in advance |
#3
|
|||
|
|||
Been there read that, didn't help. As I mentioned in my original post.
"Frank Kabel" wrote: Hi see: http://www.mcgimpsey.com/excel/timestamp.html -- Regards Frank Kabel Frankfurt, Germany "Tahlmorrah" schrieb im Newsbeitrag ... For every row when cell C<whatever is updated I need coresponding cell D<whatever to update with a date time stamp until such a time that particular cell C is updated again. Been all over the place looking at macros worksheet functions etc. and nothing quite matches what I need. Currently I am using Ctrl-Shift-; followed by Ctrl-; to quickly enter this, but there has to be a way where I do not have to enter it all. Thanks in advance |
#4
|
|||
|
|||
Perhaps if you explained why it didn't help (e.g., did you try it? Do
you not have an understanding of macros?, do you need a macro to do something different?), since your post reads exactly like the problem the site was written for, you might get a helpful answer. Saying "didn't help" is asking (volunteer) responders to play "bring me a rock". In article , "Tahlmorrah" wrote: Been there read that, didn't help. As I mentioned in my original post. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Display cell value on a chart. | Charts and Charting in Excel | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |