Good day
I need the some help with a scenario I find myself in...
I have a excel schedule that is on our server's general folder - its there for anybody to view - but in the workbook I have certain cells/ranges I only want certain people to be able to change. On one sheet I for instance have column A that needs to be changed by somebody in operations but column F needs to be changed by somebody in accounts dept. I want to give operations and accounts person each there own password - this way I know only they could have made changes.
Also is there a way for excell to track changes and list them an a new sheet within the workbook.
As always your inputs are greatly appreciated.
Regards,
Bookmarks