Completed

Macro to sort out data in correct format

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.

Skills: Data Processing, Excel, Visual Basic

See more: macro gets data website, macro extract data, convrt data date format sql, vba sort column ascending, vba sort table, excel macro button to sort data, how to create a sort macro in excel, excel macro sort data dynamic range, range.sort vba, excel macro sort data multiple columns, vba sort column a to z, excel macro move data existing cell, excel macro copy data column, macro move data cell, macro move data cell database excel, excel macro enter data database, javascript sort data, macro copy data excel, excel macro copy data windows application, excel macro paste data

About the Employer:
( 0 reviews ) Newcastle upon Tyne, United Kingdom

Project ID: #17970526

Awarded to:

SBITServices

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 re More

£40 GBP in 3 days
(385 Reviews)
7.3

34 freelancers are bidding on average £94 for this job

jaylancer43

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 Ex More

£150 GBP in 32 days
(636 Reviews)
8.3
schoudhary1553

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 conf More

£160 GBP in 3 days
(289 Reviews)
7.6
paris2785

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 t More

£90 GBP in 1 day
(162 Reviews)
6.8
TonmoyRoy111

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
(271 Reviews)
6.5
Tanmoy236

"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 mor More

£150 GBP in 3 days
(164 Reviews)
6.5
polarjin2017

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
(58 Reviews)
6.2
khudammunir

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 More

£150 GBP in 2 days
(25 Reviews)
5.1
citijayamala

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 mar More

£150 GBP in 3 days
(55 Reviews)
5.4
tiaratechies

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
(37 Reviews)
5.2
supper5guy

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
(69 Reviews)
5.3
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

£23 GBP in 1 day
(53 Reviews)
5.1
vsprybhanu

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. Macr More

£120 GBP in 1 day
(65 Reviews)
5.2
daniyal3214

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 dash More

£50 GBP in 1 day
(41 Reviews)
5.2
sloker18

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 i More

£100 GBP in 2 days
(47 Reviews)
4.9
nelumindralal

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 More

£100 GBP in 3 days
(24 Reviews)
4.3
limillion819

Hi there. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. As a professional vba developer, I ensure for a perfect ongoing project. You will n More

£111 GBP in 1 day
(7 Reviews)
3.8
prasannjeetp

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
(34 Reviews)
4.1
wiisetech

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 d More

£40 GBP in 2 days
(11 Reviews)
3.3
dataexplorer

"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 More

£150 GBP in 5 days
(13 Reviews)
3.4
egafiori

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 More

£20 GBP in 0 days
(6 Reviews)
2.2