Find Jobs
Hire Freelancers

Macro Create Report

$10-30 AUD

Completed
Posted almost 6 years ago

$10-30 AUD

Paid on delivery
Hi, I'm looking for some macro code to create a report from a table of data. Currently, the table lists out transactions with a unique value in column A. What the macro should do is: (i) look through column A, and insert a row when it comes to a new value. (ii) it should then put in column a of the blank row the value of the cell above, and the word "Total" (iii) it should then subtotal columns D & E for each row of the value in column A (iv) the macro should then highlight the total row in colour light grey
Project ID: 16800854

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 reputation points. I would like to offer my services for this project. I can easily build a macro within a few minutes to calculate totals just as you specified in the description. Could you share a sample workbook so I can check everything? I assure the best in class services and fairest prices. Do consider me once, won't dissapoint you. Would wait for a positive and prompt response from your side :) Regards Sourabh
$10 AUD in 1 day
5.0 (52 reviews)
4.8
4.8
14 freelancers are bidding on average $33 AUD for this job
User Avatar
Hi, can you please provide your source file. And a sample of 2 row for the report you want to generate, so things becomes more clear. Thanks
$30 AUD in 1 day
4.9 (238 reviews)
7.4
7.4
User Avatar
- Can get the totals as per the description of Column A, when the new value appears insert a new row and have the "Total" as the description and summarise values in Col D and Col E - Also make the totals in Grey. - Can get completed in a day. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$30 AUD in 1 day
4.6 (47 reviews)
5.9
5.9
User Avatar
Hi, Reading your project description about creating a Excel Macros that will add rows and columns and carry out summation action makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?
$30 AUD in 1 day
4.6 (30 reviews)
5.3
5.3
User Avatar
Hello sir, I can do the MACRO WORK for you... I'm good at creating MACROS, and I will provide a button for you to make this much easier... I'm suggesting to make sure your data is not bulky ....like more than 2,00,000 rows...if not the macro takes time to run..... Contact me i can give the report in 24 hours in presentable manner.
$30 AUD in 1 day
5.0 (19 reviews)
4.6
4.6
User Avatar
am not a random bidder... Please ping me if you are interested with my proposal and share more details. thank you.
$83 AUD in 1 day
4.9 (19 reviews)
4.5
4.5
User Avatar
I am proficient with excel macro/VBA development, I can write the macro to perform the 4 steps as requested in your specification, if you are interested feel free to message me, looking forward to chat further for a quick turnaround solution and work on your project
$25 AUD in 1 day
5.0 (26 reviews)
4.2
4.2
User Avatar
Hi! I would like to help you with your project, please let me know more details, or share a sample file and I will check it. Best regards, Roberto C.
$30 AUD in 2 days
5.0 (14 reviews)
3.2
3.2
User Avatar
Hi, I am a professional . I am an expert in creating macros , formulas, Vba. I have 9 years of experience. Its an easy job for me. I can do it in just few hours. Thanks
$25 AUD in 10 days
4.8 (5 reviews)
3.0
3.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
3
Payment method verified
Member since Sep 10, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.