Previous Topic Next Topic

Compilation

Closed
Wade526 Posts 2 Registration date Friday October 27, 2017 Status Member Last seen October 30, 2017 - Oct 27, 2017 at 10:36 AM
Wade526 Posts 2 Registration date Friday October 27, 2017 Status Member Last seen October 30, 2017 - Oct 30, 2017 at 12:42 PM
Good day to all,

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.

Thank you for your help

Related:

1 response

Answer 1 / 1
Blocked Profile
Oct 27, 2017 at 05:03 PM
Take a look here, and see if any of this helps, as it is code from an EVENT seat tracker i made to track an unlimited amount of seats at multiple venues!

https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
Wade526 Posts 2 Registration date Friday October 27, 2017 Status Member Last seen October 30, 2017
Oct 30, 2017 at 12:42 PM
tried to make I work for what I am looking for but still cant. I will keep doing it manually. his is too advanced for me :)

thanks for the help anyway