Completed

create excel macro for converting table

A macro shall transform a table from one format into another. The table gives time intervals and further values assigned to these intervals. I am interested in converting the time intervals (calendar data) into a series, and assigning numeric values to these intervals in the series in a consecutive order. Attached is a sample structure that gives you an impression what shall be done. So, basically, the task is the following: 1) read out the time intervals. 2) create a calendar series out of that data 3) for each column in the table, extract the numeric values 4) create a new table for each column with contains the time series (2) and the numeric values (3) Upon acceptance of the project I would submit a more detailed table.

Skills: Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: vba excel 2010 create table, vba convert range to table, excel vba table style, vba convert to table, excel vba create table from selection, macro to sort table in excel, excel macro resize table to fit data, excel vba create table dynamic range, find an engineer to create a bistable structure, create macro or formula to calculate quantity of patterns along a row of numbers, create brochure describing company structure business model culture, create macro solidworks, create macro outlook 2007 dial contact, java create excel file read file, automatically create macro outlook, create brochure decribing company structure, create macro email completed word document, create text file read file, create macro cut paste data, create macro cut paste web database

About the Employer:
( 75 reviews ) Leipzig, Germany

Project ID: #16720342

Awarded to:

sloker18

I am proficient with excel macro/VBA development, I have checked your sample file, I can write the code to retrieve and convert the data into new format as specified, if you are interested feel free to message me so we More

$20 USD in 1 day
(32 Reviews)
4.4

11 freelancers are bidding on average $25 for this job

$26 USD in 1 day
(365 Reviews)
7.3
JackieXu

hello. how are you? i am expert of python, Microsoft Word,Microsoft Excel, excel VBA and data Scraping. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best r More

$25 USD in 1 day
(34 Reviews)
4.8
INFINITYADVERT

HI, I have 9 years of experience and can do this task for you. I have understood the project. I have a great knowledge of excel. I have worked in government sector also. I will solve your problem. :) THanks

$30 USD in 0 days
(3 Reviews)
3.1
maximwang8661

i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now.

$25 USD in 1 day
(6 Reviews)
3.2
$25 USD in 1 day
(0 Reviews)
0.0
eshwar665

with my very good talent and experience of 15 years i will surely complete the given work on time and satisfy the requirements .

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
aniruddhachttrj

A proposal has not yet been provided

$20 USD in 2 days
(0 Reviews)
0.0
aseeyasubuhan

A proposal has not yet been provided

$25 USD in 2 days
(0 Reviews)
0.0
shreya1131

A proposal has not yet been provided

$30 USD in 5 days
(0 Reviews)
0.0