Devam Ediyor

508779 Simple Excel 2003 script

Urgent! Needs to be completed by Sunday night Australia time.

The spreadsheet needs to be compatible with Excel 2003, as this is the standard on work machines. So the sheet needs to be supported by scripting or macro.

The spreadsheet is designed to compare several sourcing models (Options) against Capabilities.

The user compares a capability against an option a drop down list asks then to choose from three options (example Green Amber Red). When the user selects the option the cell changes (conditional formatting) to the colour selected.

I would like the ranking of the options to change automatically. As an example if Red = 0, Amber = 1 and Green = 2, in Column B “No Change”, has a large number of Red & Green compared to the other columns shows Rank 1 in the bottom cell.

Tha table then needs tidying up in the theme colour of RED.

Should be less than 10 mins work for an expert,

regards

Bill

Beceriler: Her şey Kabul, Excel, PHP, Kabuk Betiği

Daha fazlasını görün: spreadsheet script, less excel, excel less, excel sheet expert, urgent excel, simple macro, simple excel, excel formatting, compare spreadsheet, bill compare, amber, excel colour, excel sheet formatting, excel compare list columns, spreadsheet expert excel large, excel script simple example, simple script excel, excel compare script, excel cell, excel time sheet, php excel macro, excel macro php, excel work list, large script, option spreadsheet

İşveren Hakkında:
( 6 değerlendirme ) Singapore, Australia

Proje NO: #2254706

Seçilen:

chriskerpini

Hi, Do you want the rank fields updates as the user selects from the drop down lists, or when he has fill in all the cells? Also, do you want the interior color of the cells to change to the selected color? Looking Daha fazlası

0 gün içinde 40$ USD
(38 Değerlendirme)
5.2