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: 316
microsoft-excel
|microsoft-excel-2011
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