Excel VBA code debugging - going from Mac to PC
$30-250 USD
Pago na entrega
I need a fresh set of eyes on some VBA code. I wrote some code to automate cleaning datasets (excel), analyzing them and making some graphs. The code works fine on Mac platforms but now I have to move to Windows and it is glitching.
I need someone to take a look at it and debug the code so that it runs on all platforms. It should be just a couple of hours of works. If the debugging works well, there might be a follow up project after that to refine the code and develop new functionalities.
Let me know if you are interested.
Camille
Attachments:
I am attaching three files and I am happy to clarify or provide further information about how to use them as needed:
1/ AutomationTemplate_working: my working file with the modules containing the VBA code. At this point, the four modules that I need running in Excel are CleanData, AnalysisPlan, DataAnalysis and CreateGraphs. The one glitching is mostly DataAnalysis (the code for creating pivot tables on PC is a bit different from Mac).
2/ example : provides an example of the result I expect the code to be able to produce - with CleanData sheet being the dataset, AnalysisPlan sheet on which the user can manually choose which variables to include in the data analysis, DataAnalysis in which the pivot tables are created, and Graphs sheet (in this case renamed FinalDatasheet) with the pivot graphs formatted.
3/ dataset : an example of the initial file that the code might run onto.
ID do Projeto: #21189360
Sobre o projeto
21 freelancers estão ofertando em média $131 nesse trabalho
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Mais
I can debug your vba code and make it work for windows. Please find below a brief introduction of myself. I am postgraduate with more than 6 years of experience in advanced excel based tools, VBA automation, google s Mais
Hi, dear! I've checked your project description and I've understood the requirement. I've an experience of jobs for VBA development. Please give me chance to work with you. Ping me to discuss about your project. Thank Mais
Hi, I have extensive skill and experience in Excel VBA. I can do debugging and mske sure everything is working properly in Win OS. Let's have a chat, looking forward to speaking with you.
Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language Mais
Hi Camille, I can help you with this. I am an Excel Expert with experience switching between Mac and multiple versions of Windows (I have several Mac/PC virtual machines in which I can do the testing). I will be availa Mais
Hello, I am software developer with enough experiences on C#/VB.Net, VBA for 13 years. I can work by full time for your project and trying to satisfy the requirements. Client's idea + Programmer's good coding is the pe Mais
Hello, I read your offer and I can help you. With my vast experience and my knowledge of Excel and macros, I will be able to realize this project that meets your requirements. I'm Expert in Microsoft Excel, I have 4+ Mais
I specialize in providing Excel based solutions, including template design for reporting, interactive dashboards, business and financial modeling, application development, VBA programming, and data analysis. I provide Mais
Hello, I am interested in your project, would you like to discuss further details with me! I will wait for your reply. Thank you. Regards,
Dear Sir, I have reviewed your requirement and happy to say that we can easily prepare this macro file. We have 8+ years of experience in VBA (Macros) and created multiple macro files. We can deliver this project with Mais
Hello! I've been working with VBA for over 5 years now on a daily bases, constantly learning for about 7. I work as an Automation Specialist at Market Research company, and saved it more then 32000 man hours last ye Mais
Hello, I am interested in your project and would like to invite you for further discussion. Waiting for your positive reply! Regards, Page M. O.
I have broad experience in automating and optimizing VBA scripts on excel. Efficient and elegand solutions with multiple comments explaining the process included.