J
J Brydle
Using Windows 2000 and Excel 2000:
I am constructing a spreadsheet for a survey that was recently sent out by the organization I work for. The surveys will come back over the next few months, and I am a student working here for the summer so they will need to be entered into this spreasheet after I am gone. I can add the surveys to the spreadsheet no problem on my own; I know how to add rows and update the formulas, so that's no problem. My coworkers, however, don't have the knowledge of Excel (or computers in general) to do this on their own. So I need to set the spreadsheet up in a way that is nice to look at (meaning I don't want to leave 50 blank rows) but also painfully easy to add to later on. I could show them how to add rows easily enough, and Excel 2000 appears to automatically update obvious formulas to reflect added rows (like a "total" cell directly below the column of data), but I have formulas in less obvious places, and on other sheets that do not update when I add rows.
What I really want is to have one blank row underneath the existing data, so they can fill in the answers for the next survey that comes in, and when something is written in this blank row, a new blank row automatically appears with the relevant formulas automatically updated. Is there any way to do this? I was thinking hidden rows might work, but can I have them automatically "unhide" one at a time when something is entered in the row above?
A temporary solution I've thought of for now is to have an extra blank row that is included in the formula calculations (since it's blank it doesn't affect the results), then tell my coworkers to highlight that empty row when they add a new one. That way the new row will be added within the formula range, therefore will be included. I'd rather not have to do this though, because as everyone knows, if there's a way for a computer-illiterate person to mess up instructions, it will be done. I've already learned to keep a copy of EVERYTHING I do on my own hard drive for when someone accidentally deletes everything, then accidentally saves, then accidentally restarts their computer.
Thanks so much for any help.
I am constructing a spreadsheet for a survey that was recently sent out by the organization I work for. The surveys will come back over the next few months, and I am a student working here for the summer so they will need to be entered into this spreasheet after I am gone. I can add the surveys to the spreadsheet no problem on my own; I know how to add rows and update the formulas, so that's no problem. My coworkers, however, don't have the knowledge of Excel (or computers in general) to do this on their own. So I need to set the spreadsheet up in a way that is nice to look at (meaning I don't want to leave 50 blank rows) but also painfully easy to add to later on. I could show them how to add rows easily enough, and Excel 2000 appears to automatically update obvious formulas to reflect added rows (like a "total" cell directly below the column of data), but I have formulas in less obvious places, and on other sheets that do not update when I add rows.
What I really want is to have one blank row underneath the existing data, so they can fill in the answers for the next survey that comes in, and when something is written in this blank row, a new blank row automatically appears with the relevant formulas automatically updated. Is there any way to do this? I was thinking hidden rows might work, but can I have them automatically "unhide" one at a time when something is entered in the row above?
A temporary solution I've thought of for now is to have an extra blank row that is included in the formula calculations (since it's blank it doesn't affect the results), then tell my coworkers to highlight that empty row when they add a new one. That way the new row will be added within the formula range, therefore will be included. I'd rather not have to do this though, because as everyone knows, if there's a way for a computer-illiterate person to mess up instructions, it will be done. I've already learned to keep a copy of EVERYTHING I do on my own hard drive for when someone accidentally deletes everything, then accidentally saves, then accidentally restarts their computer.
Thanks so much for any help.