Find Jobs
Hire Freelancers

Excel Macro/Advanced Formulas for Accounting Import

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I need someone to fix my macro or make this work using formulas. Either works. For some reason this doesn't work consistently and I need it to work all the time. Attached is a diagram showing what I am wanting the macro to accomplish and the spreadsheet with the macro that I thought would work. And also attached is our most currently estimating spreadsheet that I want the macro or formulas on. (dated 6.29.16). Note: the estimating sheet will be ever changing so this macro/formula needs to be dynamic with the changing cost codes and imputed costs.
Project ID: 11242522

About the project

18 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
I can work on your file as we discussed. Thanks................................................................................................
$263 USD in 3 days
5.0 (139 reviews)
7.1
7.1
18 freelancers are bidding on average $155 USD for this job
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$155 USD in 2 days
4.9 (194 reviews)
7.1
7.1
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$150 USD in 3 days
4.8 (235 reviews)
6.9
6.9
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$150 USD in 7 days
4.9 (112 reviews)
6.4
6.4
User Avatar
Hello dear client, I am interested to work with you. Please contact with me on PM for more discuss about this project. I am waiting for you. You may check my profile for more details about my past experience at-https://www.freelancer.com/u/sajibdigital.html thank you -Sajib
$250 USD in 3 days
5.0 (48 reviews)
5.5
5.5
User Avatar
I have good expertise in Excel automation using macros and VBA. Have used formulas, lookups and pivot tables. Have done data migration, comparison and validation using macros. Went through the PDF and the macro excel + another excel. I can complete this in 3 days time. My skills: - I have good skills in Excel automation and used 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. - With summary data plotting graphs, bringing pivot tables etc. - Outlook autoamtion - Peforming different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use. - Please review my portfolio on recent projects completed.
$80 USD in 3 days
5.0 (37 reviews)
5.2
5.2
User Avatar
Hello there! This seems to be workable to deliver the necessary. Please contact in personnel (message) to discuss further about this project. Kind Regards, Yogesh
$250 USD in 7 days
4.9 (14 reviews)
4.4
4.4
User Avatar
This job appears simple,- just a transfer of data from the estimate sheet to the account sheet. This can be done by formulae. The estimating can have changing values, but they must occupy the same position on the sheet. I presume this so. If not then, the formula or macro will have to search for the code, before extracting the correct value. Kindly clarify this and we can move ahead.
$100 USD in 3 days
4.5 (50 reviews)
4.9
4.9
User Avatar
Hello, I have experience in excel/macros and excel formulas. I am taking a look at your documents and will see how I can help you with this. From the higher view that I am seeing your concern, I think it should be fixed soon. Kindly message me to discuss further.
$50 USD in 3 days
4.6 (10 reviews)
3.9
3.9
User Avatar
Hi, I have 8 years experience in development and worked on many excel based macro, VBA and office addins. I looked at the attached files and it will be dynamic to grab values from cells and do calculations. thanks
$200 USD in 5 days
4.8 (2 reviews)
3.7
3.7
User Avatar
I have 10 years experience of excel programing. I am sure i will complete the task with in the required time
$30 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Ottumwa, United States
5.0
3
Payment method verified
Member since Dec 21, 2015

Client Verification

Other jobs from this client

Excel Database/Table Help
$30-250 USD
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.