Create a form as a worksheet in Excel that adds records to another worksheet

Posted by Holden Fenner on Super User See other posts from Super User or by Holden Fenner
Published on 2013-01-06T03:08:33Z Indexed on 2013/11/05 21:58 UTC
Read the original article Hit count: 322

I am trying to create a form in Excel for vehicle requests. What I want to happen is to create one worksheet that is a recreation of the current paper form, but have a clickable button that will enter all the data for the vehicle request as a record on a second worksheet. Conversely, if you know the record number, I want the form to auto-flll the information from that record number. I have the second part figured out, that should be a simple HLOOKUP, but I don't know how to generate the clickable button. Will I need to use scripting for this, or is there an pre-built way of doing this? (As an aside, I know there are other and better ways of accomplishing database work, but the nature of my work makes Excel the best choice)

© Super User or respective owner

Related posts about microsoft-excel

Related posts about microsoft-excel-2011