
Concluído
Publicado
Pago na entrega
I have a single worksheet full of raw figures. I need an Excel-VBA macro that will: • calculate the required sums and averages straight from that raw data • create two new sheets in the same workbook – Sheet 1 must hold the Raw infromation with date and time exactly as it comes in, no alterations – Sheet 2 should present the freshly calculated totals and mean values in a clear, tabular format Please keep the code lean, properly commented and triggerable by a single button or shortcut. Once done I will test it on a larger sample, so avoid hard-coding ranges; work dynamically with whatever rows I drop in. Send back the macro-enabled file (.xlsm) plus the VBA source. If anything is unclear about the layout or naming conventions, just ask and I’ll clarify quickly.
ID do Projeto: 40010949
10 propostas
Projeto remoto
Ativo há 3 meses
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos

With over five years in the software development field, I have amassed top-notch skills in mobile applications development, particularly in Android and Flutter. These skills align perfectly with this project because I understand the value of a lean and efficacious program, which I realize will be equally important for the efficient execution of your requests regarding the splitting and summarizing of your Excel raw figures. Moreover, my fluency in Dart, the programming language used in Flutter, means that I can dynamically implement an Excel-VBA macro that adapts to a more extensive range of rows. This means that no matter how large your sample becomes, you can still execute your desired calculations functionally and instantaneously using my code. Additionally, since you desire Excel outputs with no alterations to date and time values but in a clear format for ease of perception, my meticulous approach to coding will ensure that the information on Sheet 1 is replicated precisely as you desire it with Sheet 2 reflecting accurate sums and mean values.
₹2.500 INR em 7 dias
0,0
0,0
10 freelancers estão ofertando em média ₹4.287 INR for esse trabalho

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Pls check my profile to see all rating and reviews given by clients. Hoping to hear from you soon.
₹2.000 INR em 7 dias
5,0
5,0

Hi, Can you please share the excel file for me to write and test vba code. Available on chat to discuss and ready to start. Regards Imran
₹4.500 INR em 7 dias
5,0
5,0

Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA
₹2.000 INR em 1 dia
4,0
4,0

Hey there, I can do that based on the deadline you will provide If interested, kindly reach out to me! Regards, Aniket
₹4.000 INR em 2 dias
2,6
2,6

As a data wizard, I'm the perfect freelancer for your Excel macro project. My name is Nqobile Charmaine and my skills in Data Analysis are unparalleled—I can surely digest and manipulate any volume of raw figures you throw my way. Trust me, I do numbers! I'll ensure your macro does exactly what you need. The two sheets will be well differentiated; the first one with an unchanged raw data, and the second sheet presenting clear, tabular formats for calculated totals and mean values—which I won't hard-code so as to allow for dynamic range modification. Making your job easier is my mission. I know how frustrating it can be to grapple with complex tasks, but with my thoroughness and organization skills, I'll leave no stone unturned in ensuring your macro is lean, properly commented, and easily triggerable by a single button or shortcut. Overall, choosing me guarantees top-notch results—meticulous data analysis and management without stress or drama!
₹5.000 INR em 1 dia
1,4
1,4

Hello! I am very enthusiastic about your project to create an Excel VBA macro for dynamic data splitting and summarization. Automating data analysis is my specialty, and I guarantee a reliable, clean, and efficient solution that will save you significant time. I thoroughly understand the project goals: you need a macro to convert a single raw sheet into two new sheets—one for the raw data, and one for summarized totals and mean values. My proposed solution will meet all technical requirements: VBA Expertise: I have strong experience writing efficient, lean, and properly commented Visual Basic for Applications (VBA) code. Dynamic Range Handling: The macro will avoid hard-coding ranges, working dynamically with any amount of raw data you drop in. Dual Sheet Output: I will ensure Sheet 1 retains raw data exactly as entered, and Sheet 2 presents the calculated totals and averages in a clear, tabular format. One-Click Trigger: The macro will be easy to run via a single button or shortcut. Deliverables: You will receive the macro-enabled file (.xlsm) and the VBA source code. I am confident in delivering a high-quality macro quickly.
₹1.867,22 INR em 5 dias
0,0
0,0

As a diligent and methodical professional, I have spent considerable time with Ms Office, including Excel-VBA, which aligns very well with the requirements of this project. Over the years, I've acquired proficient skills in data analysis and it has been a great advantage to understand and navigate complex business data. My expertise will enable me to swiftly develop the macro you need for this project. Moreover, my approach to crafting a lean and adaptable code will ensure that your macro performs effectively even with larger data sets. I'll rigorously test the product to prevent any errors and to ensure it's easily triggered by a single button or shortcut. By entrusting me with this project, you can expect timely delivery of an excel-macro enabled file (.xlsm) as well as the VBA source code. I value clear communication and your satisfaction means a lot to me. Therefore, should there be any confusion or clarifications needed regarding layout or naming conventions, feel free to count on me for prompt responses. Looking forward to delivering precisely what you're looking for!
₹7.000 INR em 7 dias
0,0
0,0

Chennai, India
Método de pagamento verificado
Membro desde ago. 12, 2012
₹15000-20000 INR
₹600-1500 INR
$30-250 USD
₹750-1250 INR / hora
₹600-1500 INR
$25-50 USD / hora
$25-50 USD / hora
$30-250 USD
₹750-1250 INR / hora
$10-30 USD
£20-250 GBP
€30-250 EUR
$15-25 USD / hora
$15-25 USD / hora
$15-25 CAD / hora
₹100-400 INR / hora
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
$250-750 USD
$15-25 USD / hora
€750-1500 EUR
₹1500-12500 INR
£250-750 GBP
₹1500-12500 INR