Excel Macro/Formula/VBA/Programming

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

Hi,

I need someone to write the formulas, divide and sort some raw data.

I have attached an example spreadsheet in the attachment which is a rough sketch of what we are currently working on.

Basically, we need raw data from Sheet1 divided and sorted to look like data in sheet 2. We should be able to use this formula over and over for different data but in the same form. Formula should be able to handle about 1000 rows of raw data in sheet1

As we enter new data (about 1000 rows) in sheet1 in same form formula/script should automatically process it into sheet 2.

This is NOT AN EXCEL DATA ENTRY job but a rather technical job.

Ideal candidate:

Good in excel formula calculations- basically good in excel

VBA experience is a plus but not necessary

Prompt in communcation

Ability to use audio conference ([Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions])

Use Team-viewer for screen sharing

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #15829110

About the project

51 proposals Remote project Active 6 years ago

Awarded to:

beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this project. I can do an excel application to meet your requirements. Habilidades y experiencia relevante Excel expert.- I have developed a More

€30 EUR in 1 day
(181 Reviews)
6.1

51 freelancers are bidding on average €46 for this job

schoudhary1553

Greetings, I can help you in Excel Macro/Formula/VBA/Programming. Please ping me for more discussion. Please see my profile i have deliver almost 270 projects with 100% client satisfaction. Relevant Skills and Exp More

€60 EUR in 2 days
(611 Reviews)
8.6
dvcontact

Hi, Reading your project description about writing Excel macros/formulas to divide raw data from Sheet1 and sort it, makes me feel like you have me in mind when creating the project. Relevant Skills and Experience I h More

€50 EUR in 10 days
(78 Reviews)
7.0
DanielVizcaya91

Hi there, my name is Daniel and I would be glad to help you out. Relevant Skills and Experience I have plenty of experience in Excel and in VBA, which is why I am positive I can create a sheet that just by the click o More

€50 EUR in 2 days
(112 Reviews)
7.3
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications Relevant Skills and Experience I have ex More

€50 EUR in 10 days
(100 Reviews)
6.9
avinav606lx

Hi there, This looks feasible. I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman

€55 EUR in 1 day
(181 Reviews)
6.6
mail2vimalarora

Hi..having gone through your excel project details and attached excel file, I can provide you quick macro in vba that will read sheet1 and convert it into format sheet2 as shown. Relevant Skills and Experience Technic More

€39 EUR in 1 day
(122 Reviews)
6.0
zu02

Hi, I saw your project and analyze your requirements. I can code that Excel xlsm for 60 euro usd within 2 days. Thanks, Zura Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office More

€60 EUR in 2 days
(51 Reviews)
6.2
osmemon

I have 7 years of experience in Excel and VBA with 100% client satisfaction history. I can complete this project in short time and quality results. See my profile for client reviews and my portfolio Relevant Skills an More

€48 EUR in 0 days
(34 Reviews)
5.6
abhinovpankaj

-- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application Relevant Skills and Exp More

€44 EUR in 5 days
(70 Reviews)
5.7
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

€50 EUR in 1 day
(76 Reviews)
5.7
VBAautomation

My name is Deepak. I work as a full-time MS Access, Excel Programmer. I have spent the past 4+ years doing full automation, building custom applications, number crunching, and database management for MS Office business More

€55 EUR in 4 days
(28 Reviews)
5.5
WesleyJeftha

I am a fluent English speaking Excel specialist. I work quickly, accurately and professionally. Relevant Skills and Experience 1. 17 years Excel experience 2. 12 years corporate business experience 3. Fluent in Englis More

€50 EUR in 2 days
(12 Reviews)
4.9
vmadhavan15

I am not a random bidder... I hope I can do this one for you.. Please ping me if you are interested with my proposal and thank you... Relevant Skills and Experience VBA Proposed Milestones €60 EUR - final payment

€60 EUR in 3 days
(28 Reviews)
5.0
manish1988ag

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. Relevant Skills and Experience I have more then 5 years experience of advance excel such as lookup More

€34 EUR in 3 days
(14 Reviews)
3.6
mpunn2007

. Relevant Skills and Experience . Proposed Milestones €50 EUR - ms .

€50 EUR in 10 days
(9 Reviews)
3.1
dooxdino

Pozdrav, zainteresiran sam za ovaj projekt. U okviru studiranja imao sam puno prilika za susretanje i rad u Excelu. Ovaj projekt mi se čini zanimljiv i želio bih da ti pomognem u rješavanju problema. Relevant Skills a More

€50 EUR in 3 days
(3 Reviews)
2.4
lambenhlima

I master the programming VBA excel and all the required functions to meet your needs Relevant Skills and Experience mastery of Excel VBA Proposed Milestones €50 EUR - Preparation of the database, put in place the nec More

€50 EUR in 10 days
(4 Reviews)
1.8
frankokucan

This sounds like a simple VBA task. Please share more info via message. Relevant Skills and Experience Excel, Excel VBA Proposed Milestones €55 EUR - Project done

€55 EUR in 4 days
(1 Review)
2.0
AnilTitusJacob

I will put formulae in Sheet2. As soon as data is entered into Sheet1, it will be copied by formula into Sheet2 as you described. If you delete data in Sheet1 then Sheet2 data will also disappear. Relevant Skills and More

€30 EUR in 1 day
(3 Reviews)
1.5
XcelSolution

I have been working every day with Excel: formulas, databases, reports, and VBA for the past 10 years. Relevant Skills and Experience Excel: formulas, databases, reports, and VBA Proposed Milestones €30 EUR - Excel f More

€30 EUR in 5 days
(2 Reviews)
0.7