ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Fill in the blank form (https://www.excelbanter.com/new-users-excel/446969-fill-blank-form.html)

Kayden

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.

Spencer101

Quote:

Originally Posted by Kayden (Post 1605031)
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?

Kayden

Quote:

Originally Posted by Spencer101 (Post 1605052)
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".


All times are GMT +1. The time now is 08:39 AM.

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