Hi all,

I'm working in an architectural office. Currently, we have a spreadsheet in which everyone has to enter the tasks they are assigned. There are about 14 employees at this location and we have two other locations (though significantly smaller). Needless to say, inputting data into this one spreadsheet is impossible since it cannot be edited while someone else is using it.

I've tested how it may work for everyone to have their own task list and have that task list linked to a master staff allocation. The preliminary test seemed positive, but with some complications. to start, since each list will vary in length, is it possible to have excel create a table that will display linked data but ignore/hide empty lines in the linked list?

Any thoughts would be appreciated, it would be great to find a more efficient way to get into on easy-to-use staff allocation system.