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