Project Detail

Excel script

Excel script is project number 395520
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: pyazlm

Budget: $30-250

Created: 03/03/2009 at 11:51 EST

Bid Count: 13

Average Bid:
$ 58

03/08/2009 at 11:51 EDT

Project Creator: prosound
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (1 reviews)

Description

Could you please provide a quote to handle the following in a simple VBA application:

I need to format some information in an Excel file, before exporting it. All the pivot table information I have found online is primarily for account management, using counts and sums. The data is currently in this format:

DEV# WIRE#
SWITCH-1 A123
AMP-1 A124
AMP-1 A125
AMP-1 A126
SWITCH-2 A127

I need to sort it into this format in another sheet or another area in the same sheet:

DEV# WIRE#1 WIRE#2 WIRE#3
AMP-1 A124 A125 A126
SWITCH-1 A123
SWITCH-2 A127

I posted this in the following thread, but don’t have time to figure out how to create the application:

http://www.mrexcel.com/forum/showthread.php?p=1850639#post1850639

If the maximum # of wires has an impact on programming cost, 10 wires would handle 80% of our applications and 20 would handle almost every scenario.

Report Violation

Job Type

Excel

See more: account, create, data, excel, excel file, excel script, format, online, pivot table, programming, script, simple, vba

Messages Posted:1

If you are the project creator or one of the bidders Log In for more options

PMB

100

3 days

03-03-2009 12:24 EST

9.881/10
(168 reviews)

Hello,Please refer your PMB.Thank you.

svet63

2 days

03-03-2009 15:01 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(40 reviews)

VBA developer since 1997. Don't worry about the max. # of wires. Can do. Regards, Svet.

lsweb

2 days

03-03-2009 13:14 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(36 reviews)

Hello. Please check your PM. Thanks.

northwolves

0 days

03-03-2009 19:40 EST

9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10
(20 reviews)

AS an expert of this field,I'm looking forward to working with you,see PMB please

hiratariq

2 days

03-03-2009 16:40 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(18 reviews)

Hi! Please see PM.

pyazlm

2 days

03-03-2009 13:32 EST

9.9375/10
(16 reviews)

You may check PMB.

oFAZo

2 days

03-03-2009 19:30 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(5 reviews)

Exceptional quality & fast work. Please refer to Review, profile and PMB for details. Thanks FAZ

sumeet00

5 days

03-03-2009 20:26 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(5 reviews)

Hi, Check PM. Thanks and Regards, Sumeet.

monica365

3 days

03-03-2009 19:21 EST

9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10
(5 reviews)

Hi, It is possible to create a macro using VBA to rearrange the data in your spreadsheet. Kindly see my historial. Thanks! Monica

CharlesKozierok

1 day

03-03-2009 14:07 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(4 reviews)

Please see PMB.

skujuira

100

2 days

03-03-2009 14:44 EST

8.5/10 8.5/10 8.5/10 8.5/10 8.5/10 8.5/10 8.5/10 8.5/10 8.5/10 8.5/10
(2 reviews)

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

ZeusPaez

2 days

03-03-2009 13:38 EST

(No Feedback Yet)

I could do that kind of job please see my profile, I created several reports similar that your report, send me the excel file. Best Regards

pushar71

100

2 days

03-03-2009 12:50 EST

(No Feedback Yet)

pls provide me the real data file can do this proect in a day.. send me the data asa through PM if interested.

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.