ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   track changes in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/140059-track-changes-cell.html)

Wayne

track changes in a cell
 
Is there a code that I can use to track changes to a workbook that will allow
the tracking information to be stored in a different workbook.I run the
shipping dept. at my factory I want to track the product and cases that gets
removed and entered into inventory.Example Rack spot 1A has 4 rows Product
#, Cases, Date, Description.If any cell in spot 1A is changed it will record
when it was removed and or when it was changed and to what.I want to be able
to track a 30 day period.If anyone could I would be greatfull.Thanks in
advance


All times are GMT +1. The time now is 11:55 AM.

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