The sheet in excel is a duty roster for my fire department. Each day the Officer in charge would copy and paste a name from a list below the Roster into the slot that he chooses, thus assigning that person to that particular job assignment. I changed the "autocorrect" in "proofing" to replace the initials, or the first three letters of the person's name because some guys have the same initials. Now the officer in charge can just type JK in the engine 7 officer row, then " Capt. James Kite 113" for example will populate that merged cell. I did this because I couldn't word the question properly on the NET regarding this issue. Question 1: is there a better way by using an excel function? Question 2: is it complicated by obscure excel language? Also I notice that the attachment isnt "clean" like it is on my laptop. boundaries arent recognized if you get my meening.
Bookmarks