Updating excisiting Excel worksheet for technicians with VBcode
€30-250 EUR
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
Project ID: #28340919
About the project
18 freelancers are bidding on average €124 for this job
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
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
---------- 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
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
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
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.
i am Data Entry Expert and i will finish my job in given time . i have successfully completed many projects.
I can do the given job properly if u allow me. The work will be done with ur satisfaction Thankyou.
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
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
I have good experience in VBA and MS-Access applications. Have very good VB6 language experience to complete this task.
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