Hello,
I have been using excel for years, but I do not have any formal training so please be kind.
I am setting up a spreadsheet for an audit that I have to perform every month. It consists of 9 different questions that have to be answered with a "Y" or "N". Most of the time, all 9 questions are "Y". To save time when entering this data, I would like to set up a checkbox that if checked, would put a "Y" in the cells that I have linked to it and if unchecked the cells would remain blank so that I could manually enter a "Y" or "N" as needed. Since I am not an expert I have no idea if this is even possible. It seems like it should be, but I am not having much luck finding an answer. When I search I find information regarding how to link one cell to one checkbox, but not multiple cells to ONE checkbox. If there is another way to accomplish this without using the checkbox, I am open to suggestions.
Thank you
Bookmarks