VBA Excel - read and extract data excel source

Closed

Description

Hello

I have a excel sheet with some rows and columns that I need to transform to a diferent structure (somthing like unpivot).

This is 50% of the first part of a project.

Depending on cost and output, there will be a total 10 task like this one.

Please take a look at the sheet "Origin":

There are 4 parts that should be combined to create a table.

You will detect a value by a fixed cell or by a fixed text.

The structure is fixed, you read and combine the data.

I will explain in detail connecting with teamviewer. It is better to go step by step

The output will be located in a new excel sheet.

Thanks

Skills: Excel, Microsoft Access, SQL, Visual Basic

See more: table data structure, new data structure, explain data structure, a data structure, new excel, VBA Excel, read and, project on vba, excel to vba, Excel and VBA, combine excel, excel combine rows, excel combine data rows, vba extract cell, bloomberg data extract excel security name, excel read cell value, vba table transform, excel sql create, convert raw data source data pivot excel, table extract, excel macro data extract, extract data text, excel text rows, cell excel vba, vba sheet

Project ID: #6262989

Awarded to:

bouslimi1979

Dear, the project description is not clear. I can code a VBA macro to combine and create the new sheet but I need clarifications. Thanks

$45 USD in 3 days
(63 Reviews)
5.7

72 freelancers are bidding on average $87 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$100 USD in 0 days
(214 Reviews)
6.9
zExcel

Hi, I'll be happy to help you with this project. Guaranteed quick turnaround for most jobs. Please feel free to message me if you need to discuss any questions

$83 USD in 0 days
(95 Reviews)
6.4
seaanddream

Hi, your 5-star excel and vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel/vba tasks, all achieved wit More

$105 USD in 3 days
(86 Reviews)
6.3
danielgpratidya

Hi, I've checked your spreadsheet. Please let me know when you're ready to discuss this through teamviewer. I am in GMT +7. Cheers, Daniel

$50 USD in 3 days
(123 Reviews)
6.1
jhaynes75

I have 15 years of experience as a software developer and consultant with specialties in programming and relational databases. I've worked for several employers through the freelancer website and have a proven reco More

$111 USD in 5 days
(30 Reviews)
6.1
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$49 USD in 2 days
(81 Reviews)
5.9
djain01

Hello, I have more than 13 years of programming experience with Windows and Web Applications. I am well-versed with the Microsoft Technology. Proficient in programming with VB6, VB and C#.Net and different databases More

$155 USD in 3 days
(70 Reviews)
5.6
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive More

$150 USD in 10 days
(47 Reviews)
5.5
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg More

$98 USD in 5 days
(38 Reviews)
5.5
weonlydo

Hello! Not sure if you still remember me. I did some work for you many months ago. I can do this, but there is no "origin" tab in your spreadsheet! And not much description anywhere in it. Do let me know what you n More

$100 USD in 3 days
(26 Reviews)
5.2
piyushdpatel

I have 10 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start if you want i will also send demo of my work or you can download from my profile also More

$111 USD in 7 days
(17 Reviews)
5.0
ethicalboy

Hello ready to start asap to deliver you, I checked sheet1 but it seems that I should know more details so If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems More

$39 USD in 2 days
(47 Reviews)
5.0
KellogITSolution

Hi Pablo Its me John here. Looking to work with you again on this excel project. Waiting to hear from you. With Regards John

$55 USD in 3 days
(36 Reviews)
5.0
rengrish

I have 10+ years of experience in Excel & VBA. Please check my past reviews and ratings. I assure you 100% accurate & quality job. Please provide more details so that i can give you a demo work. If you are 100% More

$60 USD in 2 days
(55 Reviews)
4.8
theincredible

A proposal has not yet been provided

$150 USD in 1 day
(15 Reviews)
4.7
abdolah2014

HI I am an excel-vba expert and I can finish your project in 2 hours pm me m................................................................................

$55 USD in 3 days
(20 Reviews)
4.6
acronymsolutions

Hi, I have gone through your descriptions,I am 5+ years experienced Visual Basic,VB.NET,ASP.NET,MS SQL,SQL,SQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your job easily before your deadline . More

$126 USD in 3 days
(13 Reviews)
4.6
farr4u

A proposal has not yet been provided

$35 USD in 3 days
(31 Reviews)
4.4
AndroidAll

Dear sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. If you want, I can develop a demo within a short time. Regards. PS. In order to show my ability, I c More

$100 USD in 1 day
(13 Reviews)
4.4
Edison1983

****Similar work, I've done a lot: Please check my portfolio, Price Grabber, IOHL, Hotel Management, Survey analysis Dashboard**** Good Day!.. I'm a VBA Programmer, having around 7+ years of Experience. Have develo More

$70 USD in 0 days
(19 Reviews)
4.3