Cancelled

Excel Macro #1

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

Skills: Excel, Visual Basic

See more: would 1, m format in excel, group m, formats in excel, excel &, ask excel, successful names, n excel, Visual Basic Excel, sort excel, or 4 names are in the same column, naming, name naming, macro, macro excel, macro e, macro + excel, format excel, excel\ , excel, excel visual basic, excel projects, excel format, excel c#, excel macro sort

About the Employer:
( 0 reviews ) Glenmont, United States

Project ID: #275545

31 freelancers are bidding on average $38 for this job

ioanaprof

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.

$30 USD in 2 days
(12 Reviews)
3.5
xxxjmt

Hi Coach, please view PMB

$30 USD in 0 days
(7 Reviews)
3.2
cyberdeveloper

******************************** 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 re More

$35 USD in 3 days
(9 Reviews)
2.6
guruplus

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

$50 USD in 1 day
(1 Review)
1.9
raghavmp17

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

$48 USD in 0 days
(1 Review)
0.7
bicaig

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

$30 USD in 2 days
(0 Reviews)
0.0
vivekvelu

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.

$30 USD in 7 days
(0 Reviews)
0.0
rakhondeshyam

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

$35 USD in 1 day
(0 Reviews)
0.0
rchauhan

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 yo More

$100 USD in 7 days
(0 Reviews)
0.0
js6525

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

$30 USD in 1 day
(0 Reviews)
0.0
ivyleaguegurus

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 More

$40 USD in 2 days
(0 Reviews)
0.0
zoxno6

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

$30 USD in 0 days
(0 Reviews)
0.0
menol

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 th More

$50 USD in 2 days
(0 Reviews)
0.0
chongsa

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

$30 USD in 1 day
(0 Reviews)
0.0
Elgran

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

$30 USD in 1 day
(0 Reviews)
0.0
Seedrick

lets get started...

$30 USD in 1 day
(0 Reviews)
0.0
singular

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 considerati More

$30 USD in 1 day
(0 Reviews)
0.0
carlestops

Hello Excel VBA programmer here. I'll dot this for you if you'll hire [url removed, login to view] pm later.

$50 USD in 2 days
(0 Reviews)
0.0
dartvader

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

$50 USD in 1 day
(0 Reviews)
0.0
nunzconz

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

$45 USD in 2 days
(0 Reviews)
0.0