View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default How would I create a fillable excel spreadsheet template?

I don't suppose there is any option of creating a shared workbook and putting
it into a network accessible location for all to use? Look in Excel help for
"Share a workbook".

If that's not an option, then maybe?
Create the Excel file in the format and layout you want and simply mail a
copy of it to each of them.

Your problem is going to be when they return it back to you as an email
attachment- they are all going to still have the same name, so you'll need to
use the "Save Attachment" feature of your email client and save each one with
a different name to keep from continually overwriting the one file on your
system.

Your next problem will be to collate the information from all of the
returned workbooks into a single one. But that can be tackled later.


"bpsig6991" wrote:

I am looking to create a fillable spreadsheet template in excel that I can
email out to employees and have them enter specific and differing answers and
then be able to email back to me the altered form. How would I accomplish
this?