First post, so I'll try to stick to the rules
I'm part of the support staff at a university, and while we don't make a habit of supporting Excel, we never like to say no. The person I'm trying to assist is working with sensitive data, and for security reasons I am unable to post the Excel sheet here. Here goes:
The user is working with a sheet in which uses checkboxes, and wants to assign values from cells in the same row as the checkbox to corresponding cells in the sheet (not a different book) if the box is checked.
I guess I should just ask what the best way to accomplish this is? I was thinking I need to do an IF test (do checkboxes return TRUE/FALSE?) and then assign values from the cells I need to corresponding cells in the next sheet. The big question for me using this method: how can I use a single IF statement to assign multiple cell values? Maybe that's not even the best way to do this, I guess that's why I'm here.
Thanks for your help on this!