Form to enter data into Excel Sheet?

**Cyberpawz** · 08-31-2011, 10:53 AM

Since the template wizard with data tracking is no longer viable in Excel 2010+, I am looking for a variant that will do the same thing. Is there one?

Ok, here is what I am trying to do, just in case the answer is no.

I have attached a spreadsheet, with generic data to give an idea of what I am working on. This data needs a form in where I can enter in the information and it will self populate into this database.

Once the data is populated I have a word document that is linked to this database to print it out in a clean and organized form.

Is it possible to create an excel sheet to do this, or would I be better off using XHTML and CSS? Or is there a third option?

**royUK** · 08-31-2011, 02:05 PM

As in previous versions there's an inbuilt data entry form. First you need to add it to the QAT or the Ribbon.

Go to File menu, click Options, and in left pane click Customize Ribbon, In right pane select All Commands from Choose commands from drop-down options and look for Form command. Now from left pane, select Home and hit New Group, new group will be added to Home tab, change its name to Form, and then click Add -> button to add Form command to newly created group. Click OK to close Excel Options dialog.

Then select a cell within the data & click the icon

Not really sure why you need to involve Word though, I would set up a form within Excel & populate with VLOOKUP

**Cyberpawz** · 08-31-2011, 02:33 PM

Originally Posted by royUK

As in previous versions there's an inbuilt data entry form. First you need to add it to the QAT or the Ribbon.

Go to File menu, click Options, and in left pane click Customize Ribbon, In right pane select All Commands from Choose commands from drop-down options and look for Form command. Now from left pane, select Home and hit New Group, new group will be added to Home tab, change its name to Form, and then click Add -> button to add Form command to newly created group. Click OK to close Excel Options dialog.

Then select a cell within the data & click the icon

Not really sure why you need to involve Word though, I would set up a form within Excel & populate with VLOOKUP

I agree with using Excel for it all, but I'm not the one creating this for me, I'm creating it for my boss. You do what they say to do... with as little complaint as possible.

The concept you have in mind works, but I need to have it so that it can be clicked upon and that is where the database info is entered from. Not a floating window.

Also, I need it customizable.

Any ideas?

**royUK** · 08-31-2011, 02:47 PM

Originally Posted by Cyberpawz

The concept you have in mind works, but I need to have it so that it can be clicked upon and that is where the database info is entered from. Not a floating window.

I'm not really sure what you mean. That's the simplest way, otherwise you would need VBA - see the Contacts Form example

Also I think you will find that the Template Wizard died long before Excel 2010

**Cyberpawz** · 08-31-2011, 03:07 PM

Originally Posted by royUK

I'm not really sure what you mean. That's the simplest way, otherwise you would need VBA - see the Contacts Form example

Also I think you will find that the Template Wizard died long before Excel 2010

Right but it was still functional in 2007 versions.

Thanks for the help though.