Excel Macro/Formula/VBA/Programming

Færdiggjort Opslået 6 år siden Betalt ved levering
Færdiggjort Betalt ved levering

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

Dataindførsel Databehandling Excel Visual Basic Visual Basic for Apps

Projekt ID: #15829110

Om projektet

51 bud Remote projekt Aktiv 6 år siden

Tildelt til:

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 Flere

€30 EUR på 1 dag
(181 bedømmelser)
6.1

51 freelancere byder i gennemsnit €46 timen for dette 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 Flere

€60 EUR in 2 dage
(611 bedømmelser)
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 Flere

€50 EUR in 10 dage
(78 bedømmelser)
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 Flere

€50 EUR in 2 dage
(112 bedømmelser)
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 Flere

€50 EUR in 10 dage
(100 bedømmelser)
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 på 1 dag
(181 bedømmelser)
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 Flere

€39 EUR på 1 dag
(122 bedømmelser)
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 Flere

€60 EUR in 2 dage
(51 bedømmelser)
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 Flere

€48 EUR in 0 dage
(34 bedømmelser)
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 Flere

€44 EUR in 5 dage
(70 bedømmelser)
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 på 1 dag
(76 bedømmelser)
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 Flere

€55 EUR in 4 dage
(28 bedømmelser)
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 Flere

€50 EUR in 2 dage
(12 bedømmelser)
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 dage
(28 bedømmelser)
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 Flere

€34 EUR in 3 dage
(14 bedømmelser)
3.6
mpunn2007

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

€50 EUR in 10 dage
(9 bedømmelser)
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 Flere

€50 EUR in 3 dage
(3 bedømmelser)
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 Flere

€50 EUR in 10 dage
(4 bedømmelser)
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 dage
(1 bedømmelse)
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 Flere

€30 EUR på 1 dag
(3 bedømmelser)
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 Flere

€30 EUR in 5 dage
(2 bedømmelser)
0.7