I am trying to create a spreadsheet that has my employees listed down one side and the days of the month listed across the top. What I want to be able to do is click on a range of cells that correspond to the employees name then click a "button" that brings up a form box so that i can enter specific details approx 30 chars then automatically merges these cells and formats the colour depending on what task they are doing. That is the first hurdle

The second is that I have a number of small teams that would be able to imput the data into this spread sheet but I want to be able to view all the data together on on spreadsheet that uses theirs a a reference.

Is there anyone there that can help