Thread: Adding cells

Hi
This is probably an easy one for some but here goes. I have a master worksheet with a nominal roll of all my employees. I then have worksheets for each month of the year with all their names on and the days they have worked in that month (from 1-30). My question is, how can i add someone to the master and have the name automatically be added on the corresponding day they arrived in alphabetical order? can it be done. PS I am new to Excel

CAn you post a dummy spreadsheet as an example?

yes you can make it, all you need is to have a lookup function on the worksheets of the month.
you must lookup the data in your master worksheet.

ex. =VLOOKUP(G241,'sheet 1'!$B$2:$L$26,2,FALSE)
where ''sheet 1'' is your master worksheet