I am looking for help and I have asked all the knowledgeable people at work to no avail.
As per the uploaded picture, I am looking for the simplest solution (formula if possible) to have the following done.
Picture 1 show my working document, I am adding new events daily as a way to track how many days of tasking/event my personnel have done in the fiscal year. That being said, I am looking for a formula that will combine SOME information to a different Sheet.
IF there is an event number entered under the Event number column, I would like the start date, end date event name and the name of the people that participated to the event copied to a different Sheet.