Em Andamento

Excel If Then or Possible Macro/Script Project

Hello coders have another excel project. I have uploaded a zip file you should view before you read or bid on the project. In this excel file there are 4 tabs.

The first tab is titled 2008 Season Roster and has 2 columns. The second tab has 15 columns. What I am looking to do is do some matching up from both tabs to create an output file. In the example tab I have done the first team by hand to give a clear example. This is the process that will need to be automated or done through an excel command. All I did was copy the data for 1 team from the first 2 tabs and paste them here.

So on that tab, if any row in column A = any row in column D, AND any row in column B = any row in column E, THEN bring the corresponding row of data from column D through column R into the output page.

Basically if both teams match AND both name columns match I need the stats of the players brought over into an output page.

I have given the final solution to the first team on the output page and this is what it needs to look like for all matches. I plan to use this script or excel function with different data but same column headers and format so whatever solution you provide must be able to do the same result on a different data set.

I am also in a rush to get this done, hopefully someone can do this within 48 hours max, so please include how long it will take you to deliver in your bid.

## 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).

* * *This broadcast message was sent to all bidders on Sunday Nov 8, 2009 11:27:26 AM:

I dont know how long it takes for this to get to you, but the example file was once again uploaded for those of you that said you didn't see it attached. Some of you saw it last night, while others have sent messages that it isn't there so I dont know what happened.

## Platform

excel

Habilidades: Vale Tudo, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Tradução, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: roster example, how to get translation work, how do i get translation, hire someone to do excel, excel macro how to, example of a roster, coders for hire run your project, what is macro in excel, excel party hire, excel for hire, night view, macro e, hire macro coder, Hire Excel, excel stats, excel rush, excel function, d max project, macro script file, excel macro match data, copy paste data excel script, excel row column, excel macro row, excel program roster, excel macro program

Acerca do Empregador:
( 243 comentários ) Chicago, United States

ID do Projeto: #2954572

Premiar a:

duolevw

See private message.

$21.25 USD em 3 dias
(14 Avaliações)
3.9

28 freelancers are bidding on average $29 for this job

shikhamehta

See private message.

$15.3 USD in 3 dias
(314 Comentários)
7.0
schandraram

See private message.

$42.5 USD in 3 dias
(150 Comentários)
6.8
dominique1

See private message.

$17 USD in 3 dias
(479 Comentários)
6.6
narekGuru

See private message.

$15.3 USD in 3 dias
(148 Comentários)
6.2
slavisatosic

See private message.

$42.5 USD in 3 dias
(108 Comentários)
5.9
LogixSmith

See private message.

$12.75 USD in 3 dias
(53 Comentários)
6.0
customizedata

See private message.

$25.5 USD in 3 dias
(132 Comentários)
5.9
idealsolutionvw

See private message.

$25.5 USD in 3 dias
(109 Comentários)
5.6
BrothersTeam

See private message.

$25.5 USD in 3 dias
(127 Comentários)
5.4
Lotusdeveloper

See private message.

$22.1 USD in 3 dias
(88 Comentários)
5.3
MCATARO

See private message.

$42.5 USD in 3 dias
(41 Comentários)
5.0
vw7258315vw

See private message.

$59.5 USD in 3 dias
(52 Comentários)
4.9
ioanaprof

See private message.

$22.95 USD in 3 dias
(32 Comentários)
4.6
makjee

See private message.

$42.5 USD in 3 dias
(15 Comentários)
4.3
getitrightvw

See private message.

$25.5 USD in 3 dias
(47 Comentários)
4.1
clv

See private message.

$21.25 USD in 3 dias
(12 Comentários)
4.0
eyallev

See private message.

$34 USD in 3 dias
(7 Comentários)
3.7
jimboyvw

See private message.

$34 USD in 3 dias
(23 Comentários)
3.7
burank

See private message.

$21.25 USD in 3 dias
(25 Comentários)
3.6
daycomfreelance

See private message.

$42.5 USD in 3 dias
(7 Comentários)
2.9