Find Jobs
Hire Freelancers

Macro to sort out data in correct format

£20-250 GBP

Completed
Posted over 5 years ago

£20-250 GBP

Paid on delivery
I want to be able to take the information displayed on "raw" tab to the information shown in "complete file" so that I can easily pivot off data and do analysis The "raw" tab will have up to 200-300 more clients when normally being used. I only need to see the doctors name, inventory ID, description, total units and amount billed.
Project ID: 17970526

About the project

30 proposals
Remote project
Active 5 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 have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and completed 400+ projects. I never ask for payments in front. You can release the agreed milestones once the task is completed and you're happy with [login to view URL] my reviews to confirm my work quality With Regards, Sai
£40 GBP in 3 days
4.9 (471 reviews)
7.6
7.6
30 freelancers are bidding on average £89 GBP for this job
User Avatar
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and 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 sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
£150 GBP in 32 days
5.0 (810 reviews)
8.7
8.7
User Avatar
This is Vibrant Webtech and I was glad to see that you're looking for help for project Macro to sort out data in correct format. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Data Processing, Excel, Visual Basic. Please ping me for more discussion.
£160 GBP in 3 days
4.9 (413 reviews)
8.2
8.2
User Avatar
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to transform data from Raw sheet into the format of Complete File sheet. I'm going to write the necessary code myself. It will perform the transition when clicking a button. Just like that. I've delivered more than 250 projects in the last 5 years and this makes me very confident with your task. I can deliver the project within 1 day for 90 pounds. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Sincerely, Paris Pallas
£90 GBP in 1 day
4.9 (302 reviews)
7.8
7.8
User Avatar
Hello, we are a team of excel experts that are experienced in building the toughest macros. If you are interested talk to us.
£250 GBP in 1 day
5.0 (93 reviews)
7.4
7.4
User Avatar
Dear client I can write the macro code for you. I have previously carried out a number of projects in excel using macros. I can help you in this project. Kindly contact me for further details. Roy
£100 GBP in 2 days
4.9 (437 reviews)
7.2
7.2
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. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. 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. "
£150 GBP in 3 days
4.9 (266 reviews)
7.0
7.0
User Avatar
Hello? How are you? I have good skills in this type job... as you can see my reviews... So I can complete your job in time. Hope to work with you. Thank you.
£155 GBP in 3 days
4.8 (98 reviews)
6.7
6.7
User Avatar
I am proficient with excel macro/VBA development, I can write the macro to sort out the data of your attached workbook as specified, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project
£100 GBP in 2 days
5.0 (123 reviews)
6.6
6.6
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
£150 GBP in 2 days
5.0 (36 reviews)
6.7
6.7
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
£150 GBP in 3 days
4.7 (73 reviews)
5.8
5.8
User Avatar
I can easily perform this task for you. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated dashboards and templates for data analysis, data automation, financial modeling and various other computations, analysis and automation. I will be happy to discuss in detail regarding my qualification, experience and how I am highly suitable for this project.
£50 GBP in 1 day
4.7 (98 reviews)
6.1
6.1
User Avatar
Hello there, as an expert in excel and VBA, i can help you to accurately develop the macro to sort your data as you have specified. Please contact me and let us talk more about your project. Thanks
£50 GBP in 1 day
5.0 (83 reviews)
5.8
5.8
User Avatar
Hi, My name is Virendra an Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can create a macro which will provide a single click solution for your requirements. Macro will need to go through on "Raw" tab, extract Doctors name then again go through for specific Doctors name for other fields like Description etc. And finally you will get result on "Complete File" tab. I have excellent knowledge and experience of Manipulating Data through macro, so can do this job nicely. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
£120 GBP in 1 day
4.8 (105 reviews)
5.9
5.9
User Avatar
"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"
£150 GBP in 5 days
5.0 (20 reviews)
4.8
4.8
User Avatar
Hello, I went thru the description I will add buttons for each and every doctor's name and whenever you click that button entered data for the particular doctor, will be copied to the "complete file" and clear the entered data Today it can be started, once contacted, I will send you sample task, maybe for 1 doctor I look forward to hearing from you thanks regards Thushara
£100 GBP in 3 days
5.0 (31 reviews)
4.9
4.9
User Avatar
Hi, I am having good knowledge on excel,Macro and VBA module development. I would like to write VBA code for your mentioned process in excel so that you can proceed with the tab. Please look at my profile and portfolios. Looking forward to listen from you. Thanks Gopal
£30 GBP in 2 days
5.0 (15 reviews)
4.6
4.6
User Avatar
My name is Esteban, I'm an industrial engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression studies and statistical estimates. I would love to help you in your project and that you can help me earn more points!!
£20 GBP in 0 day
4.9 (27 reviews)
4.2
4.2
User Avatar
Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
£28 GBP in 3 days
4.4 (48 reviews)
4.6
4.6
User Avatar
Hi, I can do this job for you. I have seen the attached file. Will give you the work as per your requirements and according to your satisfaction. Deliver it on time and with quality work. Waiting for your reply to discuss. Regards.
£40 GBP in 2 days
4.8 (13 reviews)
3.4
3.4
User Avatar
Dear Sir / Madam, As an advanced excel user with valuable Financial / Analytical and Data Entry experience, I would be grateful if you would review my profile for the position advertised. Having worked at high levels within Finance, delivering accurate and timely reports to meet key deadlines has always been an essential part of the quality service I can offer. Also have vast experience in developing financial models via Excel (both basic and advanced).
£150 GBP in 3 days
5.0 (3 reviews)
3.3
3.3

About the client

Flag of UNITED KINGDOM
Sunderland, United Kingdom
5.0
1
Payment method verified
Member since Oct 16, 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.