1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

If checkbox marked, add name in a cell to a list.

Hello!

I am creating a wedding guest spreadsheet and I need some help. I am attempting to make it so that when a checkbox is filled (goes from FALSE to TRUE) then the name in the cell next to it get added to a list in a different column. Here’s an example (photos below):

If checkbox in cell D3 is filled then name in E3 (Lindsey) get added to the list in column P.

Then if checkbox in cell D 13 is filled the name in E13 (Sam - not in photo) gets added right until Lindsey in column P.

I want the names added as boxes are checked not necessarily in the order the list is already in. I hope that makes sense.

I’d like it so that if a box is checked the name they are added to the list.

Is this possible? If not, what the closest I can get?

If I need to do this on excel instead, I’m open to it.

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#checkbox
#wedding guest
#name
#list
#spreadsheet