Spreadsheet VBA - 22/11/2017 07:43 EST

VBA Code or similar. What I would like is the ability to have a search window in the header area that I can select any header column title and then search for text or numbers within that row. the spread sheet jup to what I'm looking / searching for. Example would be if I select unique joint ID number header I can then just type in the tag number or part of the tag number and it gives me a selection to pick from. Would it also be possible to have a dashboard for each header where I can input the information and it automatically gets entered to the spread sheet ? Also where it asks for dates to be entered in the spread sheet if we could have a calendar window appear when the cell is selected if possible. Most of the headers have a drop down selection I would like the aility to add to this drop down as the information amount will vary. The spread sheet will need approxamatley 10,000 rows for data to be entered. Also if we could link this to a chart that details the number of items completed daily. The chart would cover Joints Inspected, Joints assembled, Joints Torqued, Joints Tensioned, Joints Broken. Flange Registar [login to view URL]