Posts by Zytz

    Re: Check Cells In Each Row TRUE/FALSE

    Sorry, I guess I was unclear.

    Lets say the checkbox is in F1, and is checked. I'm trying to build a formula that will look to see if the box is checked, and then retrieve text/numerical data from other cells in the same row, we'll say A1,C1, and D1, and assign those values to A1, C1, and D1 in another sheet.

    I hope this clarifies what I am trying to do.



    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!