Find Jobs
Hire Freelancers

Excel Macro To Build Master Order Sheets

$250-750 USD

Closed
Posted over 6 years ago

$250-750 USD

Paid on delivery
Hello, I need to build a master order list from a master list. I have included two files. The original "Master List" and the output I need it to accomplish "Master List Complete". The original "Master List" will contain a unknown amount of rows when complied. I need the sheet names to be titled with the "Company". Each sheet will only contain the data from the "Master List" company. The final sheets need to be sorted by the "Cost" column sorting highest to lowest. Thank you JR
Project ID: 16268172

About the project

27 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
27 freelancers are bidding on average $353 USD for this job
User Avatar
I'd be happy to help you with this project. I could finish it by the end of the day if you are able to award early
$250 USD in 2 days
4.9 (250 reviews)
7.6
7.6
User Avatar
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$300 USD in 10 days
4.9 (213 reviews)
6.8
6.8
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$250 USD in 0 day
4.9 (217 reviews)
6.9
6.9
User Avatar
Hi, I have experience in automotive spare parts and inventory.I did modules in this issue including Do you want to implement a module in Microsoft Excel? seems to me that you have more items then excel can hold in one workbook. So it is important to know how much items spare parts you need to keep in a database. I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios. Also, I have experience in accounting, Financial Report Tools. I offer you 35+ years of experience working in a variety of companies including, VC's, privet investors, entrepreneurs, startups, marine and land transportation, retailers, power plants, farms, insurance, universities, real estate & constructions, medical equipment manufacturer, among others.
$650 USD in 10 days
4.9 (79 reviews)
7.0
7.0
User Avatar
Hello, I am highly skilled in Excel and can develop a VBA macro which shall create Master sheet in required format on the click of a button. Please discuss via chat. Thank you, Usman
$400 USD in 2 days
5.0 (67 reviews)
6.7
6.7
User Avatar
I read your requirements carefully and I confirm that I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
$250 USD in 2 days
4.8 (168 reviews)
7.0
7.0
User Avatar
Greetings JR! I have completed an almost similar requirement before. From that previous experience I have a very thorough understanding of the code structure and the technical details involved for such requirement (segregation of Master List data into separate tabs). Thanks to that prior experience, I can quickly get back to you with the final output (within 1 day of project award) for $100. Since you have defined the minimum budget as $250, I cannot bid lower than that. If you can initiate a chat, we can discuss how to work around this to complete the project in $100. As a freelancer I would not be able to initiate a chat myself. Being a full time freelancer working exclusively on Excel based projects, I work on developing such solutions every single day. I have 18 years experience in using Excel as part of my daily work life. In fact, over the last 19 MONTHS, I have spent at least 250 HOURS on automation in Excel every month while completing close to 160 projects on Freelancer.com Have a Great Weekend! Srinivasan
$250 USD in 1 day
5.0 (176 reviews)
6.7
6.7
User Avatar
Hi JR, I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman
$250 USD in 3 days
4.9 (160 reviews)
6.4
6.4
User Avatar
Dear Employer, I'm ready to work on "build master order list excel macro" project. Relevant Skills Excel, VBA Milestones 321 USD - code writing 80 USD - userfriendly interface I can complete your project on time and within your budget.
$401 USD in 7 days
5.0 (116 reviews)
6.5
6.5
User Avatar
Hi JR, I've done many different types of data cleansing projects similar to this one and I think I could add a lot of value to this project. Your files attached make perfect sense and you've laid out the specific requirements and desired end results perfectly. I'd love to collaborate with you on this. My only question would be: do you need a tool built where the Master List - Complete would be automatically compiled with the separate tabs for each company and sorted etc. or do you just need this Master Order List compiled once? In other words - will you need to re-use the solution, or is it just a one time data cleanse? Hopefully I can hear more and we can work together! Thanks either way and best of luck, Shaun
$250 USD in 3 days
5.0 (85 reviews)
6.5
6.5
User Avatar
Hi there, Consider the job done with perfection. Thanks
$250 USD in 1 day
4.9 (48 reviews)
6.0
6.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered eight excel vba projects in the past one month. Willing to take up your project. Deadline for the project is 24 hours. Thank you, Regards.
$250 USD in 1 day
5.0 (98 reviews)
6.1
6.1
User Avatar
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office, i can develop the best macro for your job in the least time. I will do all and extra to ensure that you won't regret giving me this project. Thanks
$250 USD in 1 day
5.0 (82 reviews)
5.8
5.8
User Avatar
Hi JR, I went through the job post and Excel files attached. I can get this completed quickly within a budget of 35 USD. Since the minimum amount posted is 250$, I am not able to quote lesser than that. If you reduce the minimum budget, I can quote for 35 $. Looking forward to hear from you. Best Regards, Akila.K
$250 USD in 1 day
5.0 (38 reviews)
5.0
5.0
User Avatar
Greeting, I have understood your Excel Macro To Build Master Order Sheets task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel
$500 USD in 5 days
4.8 (13 reviews)
5.2
5.2
User Avatar
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
$250 USD in 5 days
4.9 (30 reviews)
4.8
4.8
User Avatar
I will create a Macro that will automatically build this for you. I will not only supply the completed data file with your Company sheets in the exact format you want, but I will also provide the Macro so you won’t have to pay another Freelancer to do this in the future. Happy to discuss this if you wish.
$777 USD in 5 days
5.0 (10 reviews)
4.5
4.5
User Avatar
Hello I have examined your file and I can help you build the tool you need. I have major experience working on VBA, on similar projects as well. Don't hesitate to contact me with any question you might have. Thanks for reading, Michael.
$250 USD in 5 days
5.0 (29 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
$400 USD in 4 days
5.0 (7 reviews)
3.8
3.8
User Avatar
Dear client, I can do that task for you. I have plenty of experience in VBA macro development. The cost can also be further reduced. Looking forward
$250 USD in 7 days
4.9 (6 reviews)
3.4
3.4

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Feb 10, 2018

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.