Compilation [Closed]

Report
Posts
2
Registration date
Friday October 27, 2017
Status
Member
Last seen
October 30, 2017
-
Posts
2
Registration date
Friday October 27, 2017
Status
Member
Last seen
October 30, 2017
-
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

1 reply


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
Posts
2
Registration date
Friday October 27, 2017
Status
Member
Last seen
October 30, 2017

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!