In Progress

Data Conversion in Excel

We need to reconstruct large amount of data in Excel. We have about 60 files with 20 tabs each. From each tab we need to make one entry in the output Excel sheet, i.e. we need to make a sheet with about 1200 rows at the end. The information for the columns is scattered within each tab. Although it is not always in a fixed cell for every tab, there are pointers that say where the needed info is.

Attached are 1) a file with a sample tab with data (Note: other tabs appear in similar, but not always the same structure); 2) the output table

Skills: .NET, Data Entry, Data Processing, Excel, Visual Basic

See more: we excel, table data structure, pointers data structure, need data structure, data structure pointers, data structure note, basic data structure, n excel, large data, file conversion, data visual, sample visual basic excel, data entry visual basic, sheet excel visual basic, excel cell, excel file conversion, data table excel, excel sample file, excel data table, data sheet entry, data entry visual, tab data, excel rows, conversion file, columns excel

About the Employer:
( 2 reviews ) Rotterdam, Netherlands

Project ID: #245300

Awarded to:

cheungkc

This will be a simple looping of files and sheets, using match and index functions.

$30 USD in 3 days
(7 Reviews)
3.0

78 freelancers are bidding on average $100 for this job

svet63

VBA developer since 1997. Will automate it using VBA. Can do. Regards, Svet.

$90 USD in 3 days
(81 Reviews)
6.6
JordanEnt

Hello, We can do this with ease. We assure you of 100% accuracy. Regards, George.

$100 USD in 10 days
(56 Reviews)
6.4
zigmatech

Hi Thanks for the nice [url removed, login to view] have done many EXCEL [url removed, login to view]'s talk in PMB for our detailes. Thanks & Regards Asg for ZIGMATECH Systems ITeS Division.

$150 USD in 10 days
(41 Reviews)
5.8
dataconsultants

Please check PMB for details, Thank you

$120 USD in 2 days
(94 Reviews)
5.7
iasmumbai

Please check PMB for further details. Thanks

$40 USD in 3 days
(122 Reviews)
5.6
meparashar

Hello, I've read the description of the project and can finish this project very easily. I'm an experienced coder and have been working on freelancing site [url removed, login to view] for about a year. I'm new to this site, and More

$30 USD in 2 days
(44 Reviews)
5.4
rajanlengde

I can do it , please see PMB

$50 USD in 2 days
(31 Reviews)
5.2
VLADNOVA

Sir/Madam: This is very serious and responsible project.I am interested in and case my bid won I'm going to make everything for satisfying result. Vlad

$190 USD in 15 days
(13 Reviews)
5.0
fstudio

Dear sir, I am very interested in your project, Please see PMB for more details. Thanks. Best Regards.

$120 USD in 2 days
(23 Reviews)
4.5
johnsinit

Dear RSM Strategy! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$48 USD in 3 days
(18 Reviews)
4.3
denisCh

Ready to start now

$120 USD in 3 days
(11 Reviews)
4.3
dearpravin

please check PM

$247.8 USD in 12 days
(11 Reviews)
4.1
AmitKumarCal

Hi Check PM

$100 USD in 2 days
(6 Reviews)
3.9
trans3

Please check PM.

$100 USD in 3 days
(13 Reviews)
3.7
brohhma

hi......we have a complete set up for this! can do it without error!

$250 USD in 3 days
(10 Reviews)
3.5
statnxt

Kindly refer to your PM for details and some clarifications. Thanks!

$150 USD in 3 days
(4 Reviews)
2.9
pacejob

hello, I'm professional in data scraping, extraction, transformation and loading. thank you, pacejob

$100 USD in 2 days
(2 Reviews)
2.6
gliip1

Hello, please check your PMB. Regards

$125 USD in 20 days
(2 Reviews)
2.5
devaka

I can help you with this excell project

$150 USD in 7 days
(4 Reviews)
2.5
Kalpataru123

dear Sir, i am very interested in this project detail of the bid amount and delevery date should finalised after known the project details so please waiting for further proceed

$50 USD in 7 days
(2 Reviews)
2.1