Encerrado

MS Excel Macro

I require an Excel Macro writing that will take existing MS Excel data and manipulate it in the following ways;

1/ Some data to be parsed and extraced/deleted

2/ A new worksheet to be created by performing logic on the existing data

3/ Such logic in 2 above shall comprise of identifying the correct data from the source Excel and using this to lookup data based on the new worksheet requirements as defined.

The source Excel data comprises of data across three worksheets with fixed columns for each worksheet but a variable number of rows (typically thousands of rows). All data has a numeric primary key to identify it across the worksheets.

A new worksheet must be created with 34 column headers and a variable number of rows. Of these headers the logic will vary to calcluate the row value but the logic will consist of;

1/ Some columns are calculated by a simple direct look up i.e . the value is just a simple copy from another cell

2/ Some columns must look up text to identify a correct value from the source data and based on the text look up then populate the correct cell value

3/ Some columns require a simple logic test to check another value and adjust the text look up bases on this value.

All the logic is defined and sample source data and resulting format and logic will be supplied to suitable bidders.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: writing worksheets, writing worksheet, number writing worksheets, ms lookup, check writing worksheets, simple macro, MS excel, macro e, copy writing excel, thousands php project, excel sample project data, excel row column, excel macro row, sample copy writing test, php macro, excel column row, excel manipulate data, excel format cell, excel cell format, project macro, excel cell, php excel macro, excel macro populate worksheet, excel data management, excel macro php

Acerca do Empregador:
( 27 comentários ) United Kingdom

ID do Projeto: #3046151

22 freelancers estão ofertando em média $60 para este trabalho

waster

See private message.

$42.5 USD in 5 dias
(146 Comentários)
5.9
amcsummers

See private message.

$93.5 USD in 5 dias
(54 Comentários)
5.3
vcdanht

See private message.

$29.75 USD in 5 dias
(96 Comentários)
5.3
Lotusdeveloper

See private message.

$52.7 USD in 5 dias
(78 Comentários)
5.2
franSystems

See private message.

$41.65 USD in 5 dias
(87 Comentários)
4.8
dpune

See private message.

$42.5 USD in 5 dias
(38 Comentários)
4.8
vw7258315vw

See private message.

$59.5 USD in 5 dias
(48 Comentários)
4.7
excelsolution

See private message.

$25.5 USD in 5 dias
(58 Comentários)
4.7
nikitasvw

See private message.

$49.3 USD in 5 dias
(63 Comentários)
4.3
iqmax99

See private message.

$114.75 USD in 5 dias
(55 Comentários)
4.2
gendolftsl

See private message.

$85 USD in 5 dias
(34 Comentários)
4.1
vw7437936vw

See private message.

$42.5 USD in 5 dias
(19 Comentários)
4.1
peanuxsl

See private message.

$59.5 USD in 5 dias
(33 Comentários)
3.4
makjee

See private message.

$25.5 USD in 5 dias
(4 Comentários)
2.6
satheez1984

See private message.

$42.5 USD in 5 dias
(2 Comentários)
2.3
nerminemavw

See private message.

$42.5 USD in 5 dias
(3 Comentários)
1.5
ravindra2vw

See private message.

$59.5 USD in 5 dias
(1 Comentário)
1.4
chunlinyao

See private message.

$21.25 USD in 5 dias
(2 Comentários)
0.9
abhishekcvw

See private message.

$68 USD in 5 dias
(2 Comentários)
0.6
kcdevelopers

See private message.

$85 USD in 5 dias
(0 Comentários)
0.0