Rent A Coder - Modify an Excel VBA

Show Bid Request

Modify an Excel VBA
Bid Request Id: 50420

Bookmark in my 'To Do' list

Posted by:	melyas (17 ratings) (Software buyer rating 10)
Non-action Ratio:	Very Good - 21.62%
Buyer Security Verifications:	Good
Approved on:	Feb 27, 2003 2:15:31 PM EDT
Bidding Closes:	Feb 28, 2003 3:14:37 PM EDT
Viewed (by coders):	210 times

Phase:	100% of work completed and accepted. Coder has been paid.
Max Accepted Bid:	Bidding is closed
Project Type:	Question or Beginner / Newbie Assistance
Bidding Type:	Open Auction
Categories:	Windows, Platforms, Visual Basic, Visual Basic .Net, MS Office

Enter chat room for this bid request
(0 active users at Sep 8, 2003 8:51:19 PM EDT)

Description:

I need to change the following <a href="http://groups.google.com/groups?hl=en&lr;=&ie;=UTF-8&oe;=UTF-8&threadm;=3A0AF72C.28A189AA%40rochester.rr.com&rnum;=1&prev;=/groups%3Fq%3Dexcel%2Bvba%2Bfind%2Bunique%2Bvalues%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D3A0AF72C.28A189AA%2540rochester.rr.com%26rnum%3D1"> VBA code</a> to do this:
Prompt for Three Columns (One for Data, One for Qty, One for Results)
Identify all the Unique values in the Data Column
Display the Results in three Column as follows:
Unique Value - Total of Qty Added - # of Occurrences

Link is:

http://groups.google.com/groups?hl=en&lr;=&ie;=UTF-8&oe;=UTF-8&threadm;=3A0AF72C.28A189AA%40rochester.rr.com&rnum;=1&prev;=/groups%3Fq%3Dexcel%2Bvba%2Bfind%2Bunique%2Bvalues%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D3A0AF72C.28A189AA%2540rochester.rr.com%26rnum%3D1

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

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Complete ownership and distribution copyrights to all work purchased.

Platform:
WIN 98
EXCEL 2000
WIN XP
WIN ME

Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.

Bidding/Comments:

All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)

Name Bid Amount
Date Coder Rating

This bid was accepted by the buyer!

PVA
(30 ratings)
in Bangalore, Karnataka
India
Bid id: 542,400

$15 (USD) Feb 27, 2003
7:41:27 PM EDT 9.93
(Excellent)

Hi,
I have good expereince in Excel VBA. Done many projects in excel at Rentacoder.

Will do this work professional code and with good comments. Will use the 2nd code given by Dave. Add a user form to prompt for inputs from user.

Can you clarify this. Do you want to add unique values by currencies? Please send the xls sheet with input data and how output will need. this will help in writing the code to suit the sheet.

Thanks
PVA

There are 8 private replies to/from PVA. Click here to view them.