Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I know it's been hashed through a number of times with the answer that you can't track multi-cell changes. My question is if I can at least record who changed a cell and when... don't need to know the old or new value... only that it was changed. In my case, I have an excel workbook with about 15000 rows of data. I have data in columns A through H. If someone changes the value either in Columns C or D in row 1234, I want to put their name in cell I-1234 with today's date in cell J-1234. I can get it to work for single cell changes but want to know if it's possible to do this tracking on multi-cell changes as well. Examples being... copy and paste to many cells, drag down fills, etcl. The reason I have hope someone can help is that I don't need to know the before and after values. Thanks for any help, MikeZz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to equal a cell in another worksheet incl fill colour | Excel Worksheet Functions | |||
Format changed when the details in cell changed | Excel Worksheet Functions | |||
convert a value to a text incl apostrophe within the cell | Excel Worksheet Functions | |||
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |