Project Detail

Excel Macro #1   Trial project

Excel Macro #1 is project number 275545
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Cancelled by the Site Administrator)

Selected Providers: -

Budget: $30-250

Created: 06/17/2008 at 4:04 EDT

Bid Count: 31

Average Bid: $ 38

06/22/2008 at 4:04 EDT

Project Creator: MitchG10 View PM Post PM
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

I need a Excel macro created. I believe that they are created in Visual Basic.

I will be getting sizable databases, usually in Excel or comma delimited or text formats. I will convert them to Excel format. Then the macro can be used at the proper time.

a. Sort an Excel column #1 by account number. This should group together all the records with the same account numbers.
b. In this same numbered group of records, add together the figures in a column #2, getting a Total.
c. Place the Total in its named column #3, in dollar format.
d. Divide the Total by the number in column #4.
e. Place the answer in its named column #5, in decimal format with two places and a % sign.

I’m guessing that the format of these things is that first, the Excel macro asks the user to input info and then the macro activity is performed. The questions would ask for three column names.
a. Column #1 = naming the column name with the account number
b. Column #2 = naming the column name with the numbers to be added together
c. Column #4 = naming the column name with the number that column #2 is being divided by

I have other projects of this nature after this one has been successful. I'm seeking a relationship.

Thank you
Mitchell Goldstein - Coach Mitch

Messages Posted: 3 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options

  View PM Post PM

30

0 days

06-17-2008 11:13 EDT

Hi Coach, please view PMB

help

  View PM Post PM

30

2 days

06-17-2008 08:39 EDT

Hi, I can do your project. I think that this is just a test and I'm very interested in a collaboration in the future. I assure you that the work will be of good quality and completed on time. Thank you.

help

  View PM Post PM

50

1 day

06-17-2008 05:23 EDT

Hi, I am interested in taking up this work. Look forward your reply. Regards Bala

help

  View PM Post PM

30

1 day

06-18-2008 11:43 EDT

Hi. I'm a Canadian programmer-analyst and I specialize in just this kind of work for businesses and individuals. I'm an expert in Excel-VBA programming. Payment through GAF's escrow service. Thanks for your consideration.

help

  View PM Post PM

50

2 days

06-18-2008 08:05 EDT

Hello Excel VBA programmer here. I'll dot this for you if you'll hire me.check pm later.

help

  View PM Post PM

48

0 days

06-17-2008 06:20 EDT

(No Feedback Yet)

I am expert in Excel macros. This task will take hardly 1 to 2 hours to finish. Please give me this project.

help

  View PM Post PM

30

1 day

06-17-2008 07:38 EDT

(No Feedback Yet)

hi dear i m interested in ur work i have handled this type of work i dont have any ratings to sho for but i assure u that i will do the job on time hope to hear from u soon Regards

help

  View PM Post PM

30

2 days

06-17-2008 09:25 EDT

(No Feedback Yet)

Hi. I can do it. I have a lot of experience with Visual Basic Macros for excel. Regards, bicaig

help

  View PM Post PM

45

2 days

06-17-2008 09:27 EDT

(No Feedback Yet)

Hi coach, Can you please check my question in the question area. This bid is based on that post - which clarifies the requirements. Thanks Shane

help

  View PM Post PM

50

1 day

06-19-2008 20:05 EDT

(No Feedback Yet)

Please see PM for details

help

  View PM Post PM

35

1 day

06-17-2008 14:31 EDT

(No Feedback Yet)

Hallo, That project I can finished by tommorow morning. So if you are interested, you can provide me workbook with data. Regards, Nikita Sokoltchik

help

  View PM Post PM

30

1 day

06-17-2008 20:21 EDT

(No Feedback Yet)

Im ready to this work. Pls contact me.

help

  View PM Post PM

30

5 days

06-17-2008 21:37 EDT

(No Feedback Yet)

Your project is a very simple one. I am mechanical design engineer deeply engaged in my own profession. This freelancing job is my pass time activity. I gave 5 days to complete the job because I shall be available only after my office hrs. Exchange of several messages requires time. However I got interested because you intend to develop a future relationship. In fact what ever you wanted to do, we always do for our automatic engineering calculation sheets.

help

  View PM Post PM

30

2 days

06-18-2008 00:40 EDT

(No Feedback Yet)

I have already worked on such assignments. Waiting for your response. Regards, Sachin

help

  View PM Post PM

30

2 days

06-18-2008 02:33 EDT

(No Feedback Yet)

thanks for the offering.

help

  View PM Post PM

30

2 days

06-18-2008 03:22 EDT

(No Feedback Yet)

I can make the macro for you

help

  View PM Post PM

40

1 day

06-18-2008 04:44 EDT

(No Feedback Yet)

I wish to complete this work for you. I have provided a sample work in my PM. Thanks.

help

  View PM Post PM

35

1 day

06-18-2008 06:46 EDT

(No Feedback Yet)

plz view my excel samples

help

  View PM Post PM

30

1 day

06-18-2008 06:58 EDT

(No Feedback Yet)

Assure you a complete satisfaction and long term realtionship. This is a relationship pricing quote. Visit Profile to see similar work.Can negotiate further for $20.

help

  View PM Post PM

50

1 day

06-18-2008 08:31 EDT

(No Feedback Yet)

Hello! I am a expert in excel macro...will we start?

help

  View PM Post PM

30

7 days

06-18-2008 10:28 EDT

(No Feedback Yet)

Excellent. I have done several projects on Excel/VBA. We can work on a long term agreement. I am flexible, accurate and stick on to time schedule. Can you consider me? Have a nice day.

help

  View PM Post PM

30

1 day

06-18-2008 14:57 EDT

(No Feedback Yet)

lets get started...

help

  View PM Post PM

30

1 day

06-19-2008 02:48 EDT

(No Feedback Yet)

Hi, I am gud in excel macros. Please give me an opportunity to work with you in this project. Thanks, Elgran

help

  View PM Post PM

30

1 day

06-19-2008 03:23 EDT

(No Feedback Yet)

Experienced in Excel Macro and VBA for 15 years. Looking forward to it.

help

  View PM Post PM

50

2 days

06-19-2008 06:41 EDT

(No Feedback Yet)

Dear Sir / Madam, Actually macros are written in VBA (Visual Basic for Applications) I have good professional experience in VBA / Excel I have made a system in EXCEL for a company director which connects to their database, generated all types of reports, maintains debtors, sends emails to debtors automatically, etc. I guarantee high quality, maintainable work in a short span of time for a very reasonable price. Yours Truly, Menol

help

  View PM Post PM

30

0 days

06-19-2008 13:13 EDT

(No Feedback Yet)

Send me your excel file,please and I will done your project free!

help

  View PM Post PM

40

2 days

06-19-2008 14:11 EDT

(No Feedback Yet)

We are a small group of ivy league students. This is not our primary source of income, but we certainly don't mind the extra cash! You, the buyer, get to have your project done by us. We are responsible and we only bid on projects that we can complete.

help

  View PM Post PM

30

1 day

06-20-2008 23:23 EDT

(No Feedback Yet)

Have sample portfolio of previous excel/access work, proven track record. Quick send back time. Interested in relationship.

help

  View PM Post PM

100

7 days

06-21-2008 00:27 EDT

(No Feedback Yet)

Hi Sir, I am definately looking forward for this project; i have a team of 5 dedicated assocaites who are professional in designing and developing vba with prior experience with high end work. Look forward for your positive response. Regards, R. Chauhan [removed]

help

  View PM Post PM

35

1 day

06-21-2008 06:20 EDT

(No Feedback Yet)

Hello, I have done several similar types of projects on Excel/VBA. We can work on a long term agreement. I assure for flexibility, accuracy and stick on to time schedule. Thanks, Shyam Rakhonde

help

  View PM Post PM

35

3 days

06-21-2008 23:57 EDT

(No Feedback Yet)

******************************** Hello Sir, I'm an Excel programmer/Microsoft certified professional and I can do this application for you. Please send me the data files and I'll send you a free demo so you can see results in advance. Regards Cyberdeveloper ********************************

help

    Bid on this Project