Making note of every changes

[ankrups]

Hi there,

Currently I had setup one orders workbooks and inside there are several worksheet related to material, inventory and customer data. This file is located on public folder so everybody of the department can access it.

What I want that anybody that change anywhere in workbook it recorded with username, date and time. It also recorded location of workbook that he/she made in seperate spreadsheet.

For e.g. one of the user that made changes in [customer] worksheet in location K1.... so it should be recorded with username, date & time location [K1] in [log] worksheet...


your help is appreciated....


Ankit

 

[markyc]

Click on Tools -> Track Changes -> Highlight Changes
Whenever changes are made, Excel will keep track of them.
To see the changes go back to the Highlight Changes and click on "List Changes on a new sheet" to view them.

 

[ankrups]

thans buddy...this is very simple thing...thanks for your help ...