I am listing information about people that go into work from a course they are on. Each person has a start date, completion date, job start date and employer name. All of this information is on Sheet 1, Sheet two is used for listing each employer with how many people have started with them. How do i gather this information from sheet 1 without having to manually count each person who has started with them? Sheet 3 is a chart that shows each employer and their total and %.
Sheet 1 and 3 i have no problems with. Sheet 2 is the one that I am struggling with.
Thank you in advance.
James.
Sheet 1 and 3 i have no problems with. Sheet 2 is the one that I am struggling with.
Thank you in advance.
James.