I am trying to create an overtime chart for work that will automatically populate text in the cells adjacent to the cell where text is entered. For example, if I enter B in cell A1, I want A to automatically enter in cell B1 and C to automatically enter into B2. Is this possible? Also, can I keep the sheets separate? So it pulls the information from sheet 2 whenever the text is entered in sheet 1? So in the attached workbook it would be referring to the names in the Employee column on sheet 2. An additional question I have is would it be possible to also have a calendar on a 3rd sheet that inserts the name on the corresponding date you enter when you make an entry on sheet 1?
Attachment 629118Attachment 629119
Bookmarks