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

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

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]

Excel VBA

Project ID: #15703138

About the project

6 proposals Remote project Active 6 years ago

Awarded to:

aubrey03

I am an Excel VBA expert with a lot of experience in creating macros, userforms, dashboards, dynamic charts and complex formulas. I am more than confident that I can complete this project within your budget. Feel free More

$250 SGD in 2 days
(43 Reviews)
5.4

6 freelancers are bidding on average $443 for this job

dvcontact

Hi, Reading your project description about writing an advance Excel macro with added features makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Relevant Skills and Exper More

$300 SGD in 10 days
(18 Reviews)
5.1
Developer000

You can get my help regarding any type of VBA programming task and just i only need your continues comnmunication to make the stuff you want.

$250 SGD in 3 days
(3 Reviews)
3.5
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications Stay tuned, I'm still working on this p More

$750 SGD in 10 days
(4 Reviews)
3.1
mikhailkozalski

I am good at this part. Relevant Skills and Experience Excel VBA Proposed Milestones $555 SGD - discuss

$555 SGD in 10 days
(2 Reviews)
2.6