I need everyone to log the same information in the same order, every time; they will access from different computers on the network and save with different file names once they've entered their responses. Can regular excel do this?
2006-09-23 21:51:33 · 4 answers · asked by Kristibell 2 in Computers & Internet ➔ Software
Yes.
You can lock certain cells so that they can't be changed that way you can ask questions which are in locked cells but leave a cell free for respnses which isn't locked. It is under protection in the menus.
2006-09-23 21:54:20 · answer #1 · answered by doyler78 5 · 0⤊ 0⤋
Doyler has got it...just wanted to add that unless you add some background VBA scripting, you can't force them to enter data in the same order, if by that you mean the order in which they fill in the blanks.
2006-09-23 23:40:27 · answer #2 · answered by rabid_scientist 5 · 0⤊ 0⤋
You badly need a database .....
Quick dirty suggestion is to right click on your master file and make it read only. That way it will force them to save under a new name.
2006-09-23 21:55:15 · answer #3 · answered by teef_au 6 · 0⤊ 0⤋
s, u can... Excel 2003 has come that feature... Read Excel 2003 Documentation...
2006-09-23 21:53:30 · answer #4 · answered by gnanas_g 2 · 0⤊ 1⤋