Davealot
Member
Greetings,
I know this is simple code but for whatever stupid reason I can't figure it out. I have an employee sheet "Elist" that has two columns "First Name" as column A and "Shift" as column B. I have a separate worksheet "Alog" that is designed for attendance input with two buttons one that is "First shift" and the other for "Second shift"; I'm sure you're getting my drift. Want to be able to hit the "First shift" button; it search "Elist" for anyone that is listed as first shift and place in "Alog" starting in cell A2 their names going down the list and be done. Help me ninjas!
I know this is simple code but for whatever stupid reason I can't figure it out. I have an employee sheet "Elist" that has two columns "First Name" as column A and "Shift" as column B. I have a separate worksheet "Alog" that is designed for attendance input with two buttons one that is "First shift" and the other for "Second shift"; I'm sure you're getting my drift. Want to be able to hit the "First shift" button; it search "Elist" for anyone that is listed as first shift and place in "Alog" starting in cell A2 their names going down the list and be done. Help me ninjas!
