Excel Macro

Completado Publicado Jan 21, 2008 Pagado a la entrega
Completado Pagado a la entrega

Greetings, I need a simple Macro for Excel that will do the following: 1) Load a tab delimited text file into excel (see attached), through Explorer dialog. Resize all the column to fit the information in them 2) Add venue names from the file as new rows to the spread sheet. Then sort them alphabetically (A->Z) make sure that the other columns are going to stay with their relative rows. 3) When you add a new venue name it should have a white background color. 4) The file has 3 extra columns other than venue name: a. ticket count. b. missing venue c. G.A. when you load the file these fields should be loaded into the appropriate venue name column. 5) the columns in the spread sheet are organized according to their level of importance from left to right. left means least important, right means most important. the columns can have only a value of 0 (or empty field) or 1. The first three columns (D,E,F) can have the value 1 only in one of the columns, it cannot appear twice or more. when the value 1 is entered it should set the venue name (column A) background color to be the same as background color of the column header that has the value 1 set in it. Columns G,H can have the value 1 set at the same time. if 1 is set on both then you should take the background color of column H to be the venue name's background color. 7) Add a sum row at the bottom of the spread sheet to sum the 1 values for each column. Please specify what kind of experience you have with Excel macros. Sample files will be provided before work.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Office 2003, Windows XP.

Entrada de datos

Nº del proyecto: #3652743

Sobre el proyecto

10 propuestas Proyecto remoto Activo Jan 23, 2008

Adjudicado a:

rpivato

See private message.

$25.5 USD en 2 días
(4 comentarios)
2.3

10 freelancers están ofertando un promedio de $33 por este trabajo

pShankar2

See private message.

$42.5 USD en 2 días
(27 comentarios)
4.6
Iwin

See private message.

$42.5 USD en 2 días
(3 comentarios)
2.2
ender81

See private message.

$29.75 USD en 2 días
(2 comentarios)
0.8
danmicuda

See private message.

$29.75 USD en 2 días
(2 comentarios)
0.8
vishallx

See private message.

$42.5 USD en 2 días
(0 comentarios)
0.0
amirallesvw

See private message.

$15.3 USD en 2 días
(0 comentarios)
0.0
Zstream

See private message.

$29.75 USD en 2 días
(0 comentarios)
0.0
trichyfreelancer

See private message.

$34 USD en 2 días
(0 comentarios)
0.0
sarwatmalik

See private message.

$42.5 USD en 2 días
(1 comentario)
0.0