Hi Coders, I am looking to get this done tonight. IN your bid, please provide estimated time from acceptance to complete. See attached spreadsheet. In my original sheet (NOT provided) I already have a string of macros that copies information onto a newly created sheet. For this new sheet (the example sheet I provided): All I'd like you to to do is write one macro that will search column B for the text "average" in column B, once found, to teh left of that text (in column A), recalculate average of all the numbers from the cell above, all the way up to the cell below the next blank cell. Then after that's done, search for the next "average" below (skipping the blank cells). There are many, numerous subgroupings all of varying size (2 rows to 50 rows). Macro can replace existing average number in the cell in ColA, but must not touch any of the other cells in column A. Please provide macro, and let me test it to ensure it does what I want. And then we are done. I will be up for the next 3 hours from now.
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).
Windwos Vista Excel 2003 / Excel 2007