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!
Bookmarks