ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   tracking changes to cells (https://www.excelbanter.com/excel-programming/300965-tracking-changes-cells.html)

Chris

tracking changes to cells
 
Thanks in advance. I am trying to find a way to track
changes to individual cells. For example, I have a
workbook that is changed be a couple different users.
Cell L1 thru L? is changed between the following text
strings ( PO Received, Dead, Active/Impending,
Budget/Speculative ) If someone changes the values of the
cell, I would like to write a date into column R with the
corresponding row number. I am using Excel 2003 and any
help would be greatly appreciated.

Thanks,
Chris


Frank Kabel

tracking changes to cells
 
Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

--
Regards
Frank Kabel
Frankfurt, Germany


Chris wrote:
Thanks in advance. I am trying to find a way to track
changes to individual cells. For example, I have a
workbook that is changed be a couple different users.
Cell L1 thru L? is changed between the following text
strings ( PO Received, Dead, Active/Impending,
Budget/Speculative ) If someone changes the values of the
cell, I would like to write a date into column R with the
corresponding row number. I am using Excel 2003 and any
help would be greatly appreciated.

Thanks,
Chris



All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com