Hi All
Wanted to reach out to the experts for this. Please see attached document. This workbook is used to track upcoming sales roadshows (which last usually one week). I want to create a summary/meeting page whereby I can see how many meetings have been booked for each sales roadshow.
I've created this on the meeting count tab. You can see that i've used formula to get all the tab names into a table format.
The part i'm stuck on is how can i populate column C, D, E using formula. The numbers I need are highlighted green on all the subsequent tabs. I want to use formula rather then manually adding numbers because we are constantly adding new tabs and also new meetings and so I would want that to automatically update the summary table.
Apologies for the crappy explanation, let me know if you need more details.
Thanks,
Ahmed
Bookmarks