Excel VBA code debugging - going from Mac to PC

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.



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.

Habilidades: Coding, Programação de Banco de Dados, Visual Basic, Excel VBA, Excel Macros

Veja mais: excel vba code optmization, excel vba code optimis, excel vba code log websites, excel vba code open internet explorer, inventory excel vba code, excel vba code check add ins, excel vba code data web page, create domain class excel vba code, ftp connection excel vba code, excel vba code pull internet data, excel vba code save web page, excel vba code updater, excel vba code set picture none, excel vba code artists database, excel vba code examples update values, excel vba code convert sql vba

Acerca do Empregador:
( 0 comentários ) Paris, United States

ID do Projeto: #21189360

27 freelancers estão ofertando em média $130 para esse 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

$250 USD in 4 dias
(173 Comentários)

Hi, You won’t make the right candidate selection without knowing what your project on debugging your VBA program in order to work fine in Windows will look like. Fortunately, I can show you how your job will look like Mais

$150 USD in 3 dias
(21 Comentários)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Mais

$150 USD in 2 dias
(91 Comentários)

Hi there,I am Excel VBA/Macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within Mais

$175 USD in 3 dias
(11 Comentários)

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

$140 USD in 7 dias
(19 Comentários)

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

$120 USD em 1 dia
(15 Comentários)

⭐⭐⭐ Hello! ⭐⭐⭐ I am an expert in VBA, EXCEL fields. I have an especial interesting to VBA. I read your requirement carefully. Those are things which I have already experienced in my lives. If you choose me, I do my be Mais

$140 USD in 2 dias
(5 Comentários)

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

$30 USD em 1 dia
(3 Comentários)

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.

$61 USD em 1 dia
(9 Comentários)

hello,how are you. i read your bid carefully. i am c#/vb.net, vba expert and have full experience for 10 years. c#/vb.net, vba language is my top skill and i can give you perfect result. i can provide most quality and Mais

$200 USD in 7 dias
(1 Comentário)

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp Mais

$100 USD in 7 dias
(3 Comentários)

Hi, there! I have rich experience in Excel VBA and Software Development. I am sure I can do it perfectly. Please contact me so we can discuss more details. Thanks and Regards.

$140 USD in 7 dias
(2 Comentários)

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

$133 USD in 5 dias
(3 Comentários)

Hi Dear! Thanks for your job posting! I read your job description carefully and I have confidence to do it. I am a Visual Basic Developer with +6 years experiences and your project is very interesting for me. Then I w Mais

$140 USD in 7 dias
(1 Comentário)

This is Gopal. I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part of my daily deliverable. I am a professional account Mais

$250 USD in 7 dias
(2 Comentários)

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

$40 USD in 7 dias
(1 Comentário)

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

$200 USD in 7 dias
(1 Comentário)

sir we can done this well..............................................................................................................................................

$30 USD em 1 dia
(0 Comentários)

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.

$240 USD in 7 dias
(0 Comentários)

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

$50 USD in 2 dias
(0 Comentários)