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