1 min readfrom 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

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!

submitted by /u/CHUCKCHUCKCHUCKLES
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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