Excel Macro/Formula/VBA/Programming

완료 등록 시간: 6년 전 착불
완료 착불

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

데이터 입력 데이터 처리 엑셀 비쥬얼 베이직 앱을 위한 비주얼 베이직

프로젝트 ID: #15829110

프로젝트 소개

52 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 6년 전

수상자:

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 기타

€30 EUR (1일 이내)
(162건의 리뷰)
5.9

이 일자리에 대한 프리랜서 52 명의 평균 입찰가: €46

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 기타

€60 EUR (2일 이내)
(425 리뷰)
8.2
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 기타

€50 EUR (2일 이내)
(110 리뷰)
7.1
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 기타

€50 EUR (10일 이내)
(65 리뷰)
6.6
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 기타

€50 EUR (10일 이내)
(98 리뷰)
6.4
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 (1일 이내)
(180 리뷰)
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 기타

€39 EUR (1일 이내)
(118 리뷰)
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 기타

€60 EUR (2일 이내)
(36 리뷰)
5.8
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 기타

€55 EUR (4일 이내)
(26 리뷰)
5.3
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 기타

€48 EUR (0일 이내)
(35 리뷰)
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 기타

€44 EUR (5일 이내)
(67 리뷰)
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 (1일 이내)
(75 리뷰)
5.6
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 기타

€50 EUR (2일 이내)
(12 리뷰)
5.0
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 (3일 이내)
(28 리뷰)
5.1
mpunn2007

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

€50 EUR (10일 이내)
(9 리뷰)
3.1
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 기타

€34 EUR (3일 이내)
(14 리뷰)
3.2
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 기타

€50 EUR (3일 이내)
(3 리뷰)
2.5
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 (4일 이내)
(1 리뷰)
2.2
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 기타

€50 EUR (10일 이내)
(3 리뷰)
1.7
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 기타

€30 EUR (1일 이내)
(3 리뷰)
1.6
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 기타

€30 EUR (5일 이내)
(2 리뷰)
0.7