ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How would I create a fillable excel spreadsheet template? (https://www.excelbanter.com/excel-discussion-misc-queries/106441-how-would-i-create-fillable-excel-spreadsheet-template.html)

bpsig6991

How would I create a fillable excel spreadsheet template?
 
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?

JLatham

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?



All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com