I have a set of 20 woerksheets in Excel which detail attendees at a recent conference sessions (spread across a week). The conference had 22 separate sessions and each worksheet lists the attendeed and the time sepnt in the session. Not all the attendees joined in all of the sessions. What I need to do is generate an overall summary of everyone that attended the sessions, with the summary showing which sessions each person attended and the time spent in the session. The purpose of the summary table is as a simple lookup table that can be used to determin whether someone attended enough sessions to receive an attendance certificate and for follow-up discussions that will be running ins respect of some of the sessions
Each of the worksheets contains a list of names and duration of training for each session (ie. name (col A) time spent (col B)
The summary table should list all the attendess (col A) and each of the sessions should have a column with the attendance duration for each of the attendees listed in col A. The summary table thereby providing a one-sheet look-up for all the attendees, the sessions they attended, how long they were in the session.
57 freelancers are bidding on average £98 for this job
Hi there, Sure thing, I will create a summary sheet for you as you have mentioned in the description, Do u have the list of all the attendees? or i have to make one from all the files? can we talk? Thanks Much, RK.
Hello, I have read your project details and I would love to work on your project. I assure you accuracy and quality work. Looking forward for working with you. Regards, Hamid