C
Carole
Steph -
If it's not too late, consider creating the forms in
Excel. If the form is not too involved, you might want to
leave the first row blank, and link the data entered by
the users to the first row. (i.e. A1 would have =j9 in
it, and the data entered in j9 would be duplicated in A1,
etc). Once all the data has been completed and linked,
it's a simple matter to copy and paste the A row to a new
spreadsheet - no copying from a form with the
possibilities of error! I also would recommend changing
the color of the font to white on the first row (white on
white is a good disguise).
Hope this makes sense. If not, e-mail me back.
Carole
If it's not too late, consider creating the forms in
Excel. If the form is not too involved, you might want to
leave the first row blank, and link the data entered by
the users to the first row. (i.e. A1 would have =j9 in
it, and the data entered in j9 would be duplicated in A1,
etc). Once all the data has been completed and linked,
it's a simple matter to copy and paste the A row to a new
spreadsheet - no copying from a form with the
possibilities of error! I also would recommend changing
the color of the font to white on the first row (white on
white is a good disguise).
Hope this makes sense. If not, e-mail me back.
Carole