Hi coders I have uploaded an excel file with some data in it, download it before bidding. I am trying to do some summing up based on the data in column L. What I am looking to do is there are a bunch of different names in column L and I want a macro that will give me sum calculations for columns M through AJ and place the values in columns AJ through BF.
The important part is I want the values coming into the game/date being played, which doesn't include the current game.
So for example on line 2 in column L the name is 1997acevj001. At this point there is no prior game played so all the values would be 0. On line 3 this is the next game played for 1997acevj001 so coming into that game we would need the prior values from columns M through AJ added in. I have done a few examples to give you an idea of what I am talking about.
This is the start of a bigger project with multiple worksheets like this so I would like to find a coder or two that will be available to work on similar future projects like this fast and accurately.
I know I probably didn't explain this clearly but I can't think how to word it any better and to use the examples so if you have any questions please let me know.
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).