Updating excisiting Excel worksheet for technicians with VBcode

Closed Posted 3 years ago Paid on delivery
Closed Paid on delivery

We have an existing Excel work page with VB code that needs to be updated and finalized.

I have all the necessary code.

This Excel page and VB code works for 95%. The original programmer has no longer time to fulfill this task because he changed from worksite and has no longer spare time to do this.

I’m looking for someone experienced with Excel/Vb and who’s willing to analyze first what’s already done and how it works and use also as much as possible the excisting code.

In attachment, you’ll find the files we use for this.

It’s a worksheet for technicians, getting its data from an external/coupled xls database.

We have clients (let’s say 1.000) with some emails connected to it. The client can have several emails (for sending the worksheet, sending the invoice…). Each client has several machines (sometimes 100/client)

Each machine has some connected ’hyperlinks’ switching to drawings, manuals, info of that specific machine and stored on the computer in my office.

Also, a database with spareparts we use (let’s say 1.500) at a client with several price levels /client( not every client pays the same price for a sparepart)

Also a possibility to work as a subcontractor where some items then change in the worksheet. Client can’t see prices because the main contractor sees everything.

Each client has a specific hourly rate we work at, each machine has some time ‘connected’ to it giving us the time it takes to go to that specific machine in a factory.

If a work is not finished, the sheet is stored in a map Work Not Finished. This sheet can then be recalled to finish the job, eventually by another technician.

We have a map with Finsihed Jobs.

We have a map with Maintenance.

We can look in the history and do a search in different ways. The VB-search module is already made and works fine.

The worksheet is sent to a specific email as a pdf and/or as an xls file on the main computer.

All this is already working and programmed.

Reading a QR code is still needed so that we can scan a code attached toe each machine and the code automatically finds the machine/client and its history so that the technician doesn't need to fill in the whole worksheet.

Code still needs to be finetuned.

The project is running on a PC in my office and the intention is to connect via Teamviewer or something similar and fill in the worksheet.

Better should be that we can do it on-site on a tablet or a laptop and that we can store it then somewhere in the cloud. Cloud is what I prefer. This is not done this way yet and I’m listening to your proposal because this should make it a much better way of working for us.

The original programmer had not enough experience to accomplish this.

I’m also willing to listen if you can re-code this so that it works better, faster…as long as everything we need is implemented.

So, analyze first what is already done and make me a proposal. I’m also interested if you can re-program it eventually so that it looks nicer.

I also want that you mention very specifically that you have read all what’s explained above because my experience is that many sent me immediately after posting an automated or standard message.

So automated or standard messages will be deleted immdiately

I want anyhow a price span for this job and I don’t want someone who’s working on an hourly base where I have the chance that I’m paying for someone not experienced with this kind of job and where I ‘m paying someone to improve his Excel Skills. This is what happened in another project.

Good communication is essential

Excel Excel VBA

Project ID: #28340919

About the project

18 proposals Remote project Active 3 years ago

18 freelancers are bidding on average €124 for this job

schoudhary1553

Hi, Greetings! ✅checked your project details: Updating excisiting Excel worksheet for technicians with VBcode ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the exper More

€220 EUR in 4 days
(402 Reviews)
8.2
daniyal3214

I can perfectly help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data A More

€40 EUR in 1 day
(121 Reviews)
6.7
AnowarRatul

---------- EXCEL EXPERT ---------- I CAN START RIGHT AWAY ---------------- Hello, I have read your project details carefully . I can do this formula work as your requirements by maintaining 100% accuracy of your data a More

€59 EUR in 1 day
(284 Reviews)
6.4
FaiziTechy

I have read your project description and it meets to my expertise. I will complete your requirement in quick turn around with right quality. Send me your file to review and I will let you know how fast I can solve it. More

€111 EUR in 2 days
(11 Reviews)
4.5
rameshraja86

Hi Greetings... I understand that you are looking for VBA expert to develop the Excel sheet I am an expert especially in Excel VBA development Please check my profile and previous projects that are only belongs to E More

€250 EUR in 4 days
(28 Reviews)
4.7
aarianaa

Hi, this is Ariana First of all, thanks for your complete and detailed explanation. I have a great background of working with Microsoft office. Excel and PowerPoint were always my favorite ones. About 7 years ago I sta More

€98 EUR in 7 days
(8 Reviews)
3.7
chnsci

Greetings, I think here you are looking for someone to Update excisiting Excel worksheet for technicians with VBcode. I have seen the attached files and understood your project description. I am an expert in Excel, More

€140 EUR in 4 days
(9 Reviews)
2.9
rahulgoswami2001

Hi, I can accomplish your task accurately. You can see my portfolios as a sample. We can discuss further details over chat. I look forward to hearing from you. Thanks.

€70 EUR in 5 days
(2 Reviews)
0.9
sonuroy87

i am Data Entry Expert and i will finish my job in given time . i have successfully completed many projects.

€120 EUR in 8 days
(0 Reviews)
0.0
hashimumair34

I can do the given job properly if u allow me. The work will be done with ur satisfaction Thankyou.

€100 EUR in 10 days
(0 Reviews)
0.0
bilkis5

hi sir I am interested in your work . I can configure expert excel very will for exceI's work perfect all right time what I can do thsnk you sir

€140 EUR in 7 days
(0 Reviews)
0.0
automatedata111

After reading your description, I think, your almost all work has done related file data transfer related to from client to machine and machine to client basis on certain heirachy. you need only automation to read QR c More

€30 EUR in 7 days
(0 Reviews)
0.0
pratapaluru

I have good experience in VBA and MS-Access applications. Have very good VB6 language experience to complete this task.

€250 EUR in 7 days
(0 Reviews)
0.0
hardikkhatri111

Hello, I have read your project details carefully . I can do this formula work as your requirements by maintaining 100% accuracy of your data absolutely as you want. VBA Macro Coding, Formula Generation and Automation More

€100 EUR in 3 days
(0 Reviews)
0.0