•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
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#AI formula generation techniques#Excel compatibility#financial modeling with spreadsheets#formula generator#Excel alternatives#multi day event#on site