Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 28th 12, 09:54 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 2
Default Fill in the blank form

OK I'm about as new to Excel as one can be, (normally I drive a patrol car but while I recover from an injury I'm driving a desk) I have to figure there is a way to create a "Fill in the blank and check the box" form that will auto populate cells in an Excel spreadsheet. The form will be posted on an "Employee Only" web site. Can anyone walk me through creating the form? The current process involves an MS Word form that is filled out online, emailed, printed and then the information is hand entered into Excel which is what I get to do from behind this desk.

  #2   Report Post  
Old August 29th 12, 07:10 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by Kayden View Post
OK I'm about as new to Excel as one can be, (normally I drive a patrol car but while I recover from an injury I'm driving a desk) I have to figure there is a way to create a "Fill in the blank and check the box" form that will auto populate cells in an Excel spreadsheet. The form will be posted on an "Employee Only" web site. Can anyone walk me through creating the form? The current process involves an MS Word form that is filled out online, emailed, printed and then the information is hand entered into Excel which is what I get to do from behind this desk.
Hi Kayden,

Do you mean an electronic representation of the form that gets emailed and printed which will allow you to easily enter the data from the form and turn it into a usable spreadsheet?
  #3   Report Post  
Old September 4th 12, 06:48 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 2
Default

Quote:
Originally Posted by Spencer101 View Post
Hi Kayden,

Do you mean an electronic representation of the form that gets emailed and printed which will allow you to easily enter the data from the form and turn it into a usable spreadsheet?
Spencer,

What I am hoping to to, (and maybe this isn't possible), is create a form that gets posted on a secure intranet site, that will allow the user to fill in the blanks and automatically capture the data entered in a backgroung spreadsheet, once the used hits "Submit" or "Send".


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
Fill/Copy Up to fill blank cells. J.W. Aldridge Excel Programming 3 September 26th 08 05:01 PM
fill in the blank form beck Excel Discussion (Misc queries) 1 July 29th 08 07:53 PM
How do I fill a cell in a user form from a selection on same form? Terry Tipsy Excel Discussion (Misc queries) 4 June 11th 07 02:59 PM
Fill in the blank cybergardener Excel Discussion (Misc queries) 1 August 11th 06 11:15 PM
Fill in form to type Item descrictions and costs and fill in funct cradino Excel Worksheet Functions 0 July 16th 06 08:44 PM


All times are GMT +1. The time now is 03:58 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017