Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing links from access to excel to template jwr Links and Linking in Excel 1 February 5th 06 06:42 PM
HOW TO CREATE A LETTER TEMPLATE IN EXCEL? Ravindra.C Excel Discussion (Misc queries) 1 January 30th 06 04:25 PM
How to create default template in Excel 2002 [email protected] Excel Discussion (Misc queries) 4 January 27th 06 06:01 PM
Need One Excel Template to copy to TWO Databases gildo4realdo Excel Discussion (Misc queries) 0 July 29th 05 03:57 PM
create excel spreadsheet to display data from filled text forms pluck4me Excel Discussion (Misc queries) 0 April 20th 05 08:37 PM


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"