Em Andamento

Order overview afd 57

In an excel 2003 worksheet orders are sorted to get an overview.

The programming that has to be done, can be placed in 2 items:

a) Sorting

b) Color code according to date

a) Sorting

The attached worksheet has 3 "Sortering" (sort) pushbuttons.

Sort direction is top-down for all 3 pushbuttons.

1) "Ordre nr."? This one is working, sorting the order no.

2) "Leverings dato" has a pushbutton that should sort the projects in date order. If no date or text these shall be sorted first.

3) "El-ingeniør" has the third sort pushbutton, and sort with:

? 1 st priority: all "BWF" first, then all "CTN" and so on.

? 2 nd priority: "Leveringsdato" (Date)? If no date or text these shall be sorted first.

b) Colorcode

In the column "TASK STATUS", which are represented 2 places, the color of the cell should represent this color code:

- WHITE if no date is present to the left of the cell? ("TASK STATUS") or if todays date not is *overdue* compared? to the left of the cell? ("TASK STATUS")

- RED if todays date is *overdue*? compared to the date cell to the left and no "OK"? is present to the right of the cell ("TASK STATUS")?

- GREEN if there is an "OK"? present to the right of the cell ("TASK STATUS")

PS. With *overdue* there should be a cell used as OFFSET meaning the color change can be OFFSET meaning there can be inserted a value from 0-20 days.

Habilidades: Engenharia, Microsoft, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Visual Basic para Apps, Área de trabalho do Windows

Ver mais: top programming, excel sort date, windows order, sort excel date, white order, excel color cell, excel sorting, red status code, direction left right, order windows, excel 2003 programming, excel order, order excel, programming excel 2003, todays projects, sort order php, red windows, projects order, order items php, change order status php, order status php, red windows 2003, php color sorting, sorting text, cell projects

Acerca do Empregador:
( 3 comentários ) Denmark

ID do Projeto: #3008293

Premiar a:

tusharvv

See private message.

$63.75 USD em 6 dias
(67 Avaliações)
5.0

6 freelancers estão ofertando em média $47 para este trabalho

azrajobs

See private message.

$63.75 USD in 6 dias
(48 Comentários)
5.0
excelsolution

See private message.

$17 USD in 6 dias
(64 Comentários)
4.8
abhaysinghb

See private message.

$51 USD in 6 dias
(9 Comentários)
3.8
SHhadun

See private message.

$29.75 USD in 6 dias
(22 Comentários)
3.8
ivyleaguegurus

See private message.

$59.5 USD in 6 dias
(0 Comentários)
0.0