2
2
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)
@NickPerkins Does not look like an answer to me. Looks like guidance – Prasanna – 2015-05-13T07:56:03.260
Access might be better for this – Sam – 2013-01-06T06:37:23.210
How much VBa do you know? I am certain you will need scripting as this is a very bespoke request. – Dave – 2013-01-06T07:03:00.283
I don't know VBA, but I'm sure I could figure it out. Before I started scripting, I wanted to make sure there wasn't a more obvious solution. And yes, Access (or really any database) would be better suited to this, but everybody at my work has Excel and if they needed to could continue to manually manipulate a spreadsheet. We're talking a place that is still pretty low tech and lives off the three big Microsoft Office products. – eightbitdino – 2013-01-06T13:46:43.867
@HoldenFenner I'm just wondering if my answer was of any use. – Nick Perkins – 2013-01-11T01:26:34.260