Posts by Zytz

  • Check Cells In Each Row TRUE/FALSE

    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.


    Thanks!

  • Check Cells In Each Row TRUE/FALSE

    Hello,


    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!