If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Creating an employee leave and tasking spreadsheet

Thread starter Guest
Start date Mar 12, 2002

Guest

Mar 12, 2002

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