Problem is that the process we are tracking Excel with requires one
department to enter data, then the next department, then the next, and so on.
And while that happens for one item, the first department also adds new
items to the list. So at any time, there are multiple people filling in
information along the responsibility chain of process flow.

This would be much better in Access, but they don't have that. Not sure if
they have the latest Excel, but maybe the regions of cells approach could
work.
--
Boris


"Pete_UK" wrote:

Password protection is not very secure in Excel. Why do the departments
need to see what other departments have filled in? Is one department's
data entry dependent on another department's? If not, then why not just
give each department their own file with a single sheet in it, then
when they are completed and returned to you then you can merge them
together in the way you are planning now.

Hope this helps.

Pete