Find Jobs
Hire Freelancers

Build a macro in Microsoft Excel

$30-250 AUD

Completed
Posted about 8 years ago

$30-250 AUD

Paid on delivery
Build a macro that will do the following: Select date columns (columns J & O) right click and format as Date - DD/MM/YYYY Select Contract-No Column C – format as a number, no decimal places, no comma separator Select Revenue Columns K-M and Q-S right click and format as a number, 2 decimal places, no comma separator If any fields are blank in the following columns – copy from the column as indicated (this applies if you choose to import practice fees and allowances noted at the end of the spreadsheet, immediately prior to the summary lines If this column has a blank cell Copy data from this cell Column C – Contract-No Column I – Product-Name Column E – Sales-No Column F – Owner-No Column H – Client Name Column G – Owner-Name Column J – Movt-Eft-Date Column O – Settlemnt-Date Delete summary rows at the end of the document - “If you have any enquiries….” Up to and including “END OF FILE” row
Project ID: 9828769

About the project

31 proposals
Remote project
Active 8 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 , I would like to work on your project. I have great experience using excel, and macros / vba. My strongest part is data manipulation in excel through vba code. I intend to create macro launched from 1 command button or keyboard shortcut to do describing [login to view URL] please your data file to work directly on it, I can start right now. Thank you. Regards
$30 AUD in 1 day
5.0 (133 reviews)
6.6
6.6
31 freelancers are bidding on average $74 AUD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$70 AUD in 0 day
5.0 (765 reviews)
8.6
8.6
User Avatar
Hi, I am an Excel macro expert and would be happy to take on your project. Let me know and kindly provide sample file with data. Regards, Arul
$75 AUD in 1 day
5.0 (173 reviews)
7.4
7.4
User Avatar
EXCEL/VBA expert at you service. Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$50 AUD in 0 day
4.9 (326 reviews)
7.6
7.6
User Avatar
I can do it for you quickly and exactly
$70 AUD in 0 day
4.9 (115 reviews)
7.0
7.0
User Avatar
Hi Sir, I can write the required macro within a couple of hours. Please discuss so we may begin. Thank you, Usman.
$80 AUD in 1 day
5.0 (70 reviews)
6.7
6.7
User Avatar
Hi, I would love to work on this project. I am a qualified chartered accountant (CPA equivalent). I have 8 years of rich experience in Microsoft Excel including working with financial modeling, macros and dashboards. Please contact with further details if interested. Regards CA Raghav Bansal
$126 AUD in 2 days
4.9 (95 reviews)
6.5
6.5
User Avatar
Can you please share the spreadsheet? I can create a macro to perform the described actions. .
$55 AUD in 1 day
5.0 (145 reviews)
6.3
6.3
User Avatar
I can complete the job within 2 hours . Please check my past reviews. I have 10+ years of experience in Excel & VBA. I assure you 100% accurate solution. Please ping back the file. Thank You Regards Rishi
$60 AUD in 1 day
4.9 (146 reviews)
5.9
5.9
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 60+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$34 AUD in 3 days
4.8 (72 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$35 AUD in 3 days
4.9 (28 reviews)
4.7
4.7
User Avatar
Hi, We are experts in Excel based operations and we can do this job really quickly. Kindly let us know if you want to discuss. Regards, Pal
$30 AUD in 3 days
5.0 (24 reviews)
4.8
4.8
User Avatar
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details
$55 AUD in 0 day
5.0 (48 reviews)
4.6
4.6
User Avatar
Hello, I am interesting to your project and placed bid for your consideration. With my experience in excel formulas, template's and macro I am confident that I will able to complete your project as per timeline and requirement. Appreciate if we can talk thought pm before project awarded. Looking forward to hearing good news from you. Thanks & Regards, GS-Anggara
$50 AUD in 1 day
4.9 (27 reviews)
4.2
4.2
User Avatar
Hi, This is an intersting project. I will complete it today. Please contact me for further details of your project. Thanks!
$66 AUD in 1 day
4.6 (12 reviews)
3.8
3.8
User Avatar
Local Australian with extensive excel/vba experience in an reporting and analytics. Ive worked as an operations analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating automated solutions in excel to drive optimisation. Can start immediately get this done for you quickly and accurately.
$111 AUD in 1 day
3.9 (3 reviews)
3.4
3.4
User Avatar
I have 4 yrs experience in excel macro. I can create an add-ins for excel. I did few automation for my organization research team. currently I am working in on automation process. I can do this at the earliest time.
$111 AUD in 3 days
5.0 (1 review)
0.4
0.4
User Avatar
Ready to start RIGHT now dear and give you 100% need and clear task all time and check and will dubble check your task.
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I am an Electrical Engineer with 2 years Experience using VBA, Excel. I have also experience with data scrapping, please send me the Excel file. I hope that my work satisfies your requirements, and I also hope to start working on Freelance with you, Please review the proposed milestones I am free to start the work immediately and to deliver the work as fast as possible. Best Regards. Ahmed.
$50 AUD in 0 day
5.0 (2 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam, The project can be completed well in time with 100% accuracy.I had developed a lot of macros to simplify my routine work. Regards Reji Joseph
$45 AUD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I may be new but I am old in experience . I assure you that I will deliver the work with maximum satisfaction. I have 7 years of working experience on excel. Thanks Amit
$100 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Payneham, Australia
5.0
54
Payment method verified
Member since Jan 8, 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.