Em Andamento

I need a professional in Excel VBA programming to create reports for me

I have a huge array of data (children's grade results) in an existing spreadsheet. (The sample provided is not the finished product - it only consists of the first three children in Reading). The children's grades are presented by colouring in cells in excel (red, green or yellow depending on whether they have met the target). Their grade is calculated via a look up table depending on how many of the cells are coloured green. If a child has not met 1c, they are classified as being ELG and need a separate individual record for those assessment criteria (as can hopefully be seen by the two separate word documents).

I need some form of VBA programming to transfer these colored cells into the Word document provided below. Ideally, this would be in Word, but it could also be transferred into Excel if necessary. Basically, I want to be able to press a button, and Excel creates reports automatically for me for 30 children in three different subjects. (So 90 sheets).

The sample files I have provided are just for one subject (reading) but I would need the same programming for writing and maths respectively.

I hope I have explained this sufficiently, but it is rather complicated, so I invite your questions if this needs further clarification. Many thanks and I look forward to hearing from you.

Habilidades: Processamento de Dados, Processamento de dados, Excel

Ver mais: writing sheets, vba excel programming, vba excel professional programming, programming vba, programming excel vba, programming excel 2013, programming children, professional writing sample, professional press, writing first grade, first grade writing, excel programming vba, excel data programming, children programming, professional want, me vba, excel 2013 vba, child data entry, vba word, vba excel, transfer product data, invite, elg, transfer data spreadsheet, word programming

Acerca do Empregador:
( 2 comentários ) Istanbul, Turkey

ID do Projeto: #5128463

Premiar a:

yes0

I read through the job details extremely carefully and understand you’re required, for this I am absolutely sure that I can do the project very well. I can complete your project on time and within your budget. I have w Mais

$2 USD / hora
(2 Avaliações)
0.0

12 freelancers estão ofertando em média $3/hora para este trabalho

dpune

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

$5 USD / hora
(69 Comentários)
5.4
alicja1234

Hello, ready to start. I have an experience with converting databases.Please see my portfolio. You can rely on my work ,because I am concentrated on details. Best regards Alicja

$3 USD / hora
(1 Comentário)
2.1
ester81

Project Description: I have a huge array of data (children's grade results) in an existing spreadsheet. (The sample provided is not the finished product - it only consists of the first three children in Reading). The Mais

$5 USD / hora
(1 Comentário)
0.5
yubor

Hi. I have great xp in VBA developing. Would be glad to help you with this project. Regards, Yuri .

$4 USD / hora
(1 Comentário)
0.2
paritoshikpaul

I also have some experience in the following areas: *Business Systems (Inventory and Billing System, Stock Management System, Hospital System, Point of Mais

$4 USD / hora
(0 Comentários)
0.0
finmodeller

A proposal has not yet been provided

$3 USD / hora
(0 Comentários)
0.0
mvmanjula4u

A proposal has not yet been provided

$3 USD / hora
(0 Comentários)
0.0
nadeekasenevirat

Dear Hiring Manager I'm very interested in your job post involving these skills. I have about 11 years experience in Accounting, Computer field (Ms Word, MS Excel, MS office Graphics, PDF) and office operations i Mais

$3 USD / hora
(0 Comentários)
0.0
universalsols

A proposal has not yet been provided

$3 USD / hora
(0 Comentários)
0.0
SWAPANCHOWHAN

hii i m interested in your project i have 5 years experience in excel i m already doing this kind of project so kindly consider my bid... you can see the sample in my portfolio

$3 USD / hora
(0 Comentários)
0.0
nurulammelia

since school or organization,i was the one who hold the position of secretary,so i am expert on the skills of fill in,sort and manage the data.So,i was very appreciated if you can give me opportunity to finish up your Mais

$3 USD / hora
(0 Comentários)
0.0