•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Hosting multi day event and need to be able to filter who will be on site for each day
Our take
If you're hosting a multi-day event and need a streamlined way to identify attendees on-site each day, you're in the right place. With your existing data sheet containing essential details like names, companies, and attendance dates, you can create individual sheets for each event day. This approach allows you to automatically populate each daily sheet with the relevant attendees, including all their information or specific details as needed. This method not only simplifies your planning process but also enhances your event organization.
I've got a 15 day event coming up, and I need a list of who will be on site each day.
I've got one sheet with all the data (name, company, phone, first day onsite, last day onsite, etc). I'd like to be able to make a sheet for each day of the event that presents the people who will be on site that day. So on a new sheet for May 1, it'll populate everyone from the "data" sheet who will be at the event May 1, and have this continue for one sheet for each day of the event. Is this possible/feasible? Will the formula populate all of the information for that person (or can I select specific info) or just the name? Thank you!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience