+ Reply to Thread
Results 1 to 2 of 2

Fill in fields based on a "checkbox"

  1. #1
    Registered User
    Join Date
    06-01-2010
    Location
    MA, USA
    MS-Off Ver
    Excel 2013
    Posts
    18

    Fill in fields based on a "checkbox"

    Not sure how to explain this best here, but here's what I've got:

    Cells O1 through R1 need to be filled out in order to calculate a number of other fields in columns B through M.
    There are 1 to 7 options for what data should go in O1 through R1. Those data selections are (O6 through R6) through (O12 through R12). That is to say that ALL the fields in each row need to be in Row 1 in order to perform the above calculations. There will be a minimum of 1 option (O6 through R6) to a maximum of 7 options (O6 through R6, O7 through R7, O8 through R8, etc). Each user of the spreadsheet will have a different number of options depending on their individual requirements.

    Rather than having each user make selections from each row, I would like to set a "checkbox" in Column N such that if N7<>"", then O1 through R1 will be filled in with the data in O7 through R7. That way when a user wants to calculate new data, all they have to do is change the checkbox, as opposed to copy and paste out of the options.

    Is this possible, and if so how? Thanks!

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Fill in fields based on a "checkbox"

    Here's a sample. Hope I got the ranges correct.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1