Project Detail

VBA / Excel Macros  

VBA / Excel Macros is project number 522778
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: vserv

Budget: $30-250

Created: 10/06/2009 at 20:39 EDT

Bid Count: 51

Average Bid:
$ 65

10/10/2009 at 20:39 EDT

Project Creator: dwepplo
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

I need two VBA Macros for excel.

Macro 1 – Import data from a text file into proper format and organize.
Macro 2 – Matching of data from the newly imported data and an exsiting sheet.


Attachments:

DATA.txt - contains a sample set of the raw data to be imported and organized.

SampleWB.xls – excel work book with three sheets
* Main – a listing and description of the parameters
* DATA – Desired form of the finished data with explinations where the data comes from
* Times – data that will be supplied by user.

Project Description.PDF - Details the columns and where the data comes from


I hope I included enough information, if not please contact. On complition I'd like to see it work on a data set I provide. I look forward to hearing from you.

Thank you,
Dan


Additional files submitted:
DATA.txt
Project description.pdf
Sample WB.xls

Messages Posted:1 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

 

75

0 days

10-07-2009 01:49 EDT

Looking forward to working with you...

help

 

120

2 days

10-06-2009 20:59 EDT

Hi, please view my PM for details, thanks.

help

 

58

2 days

10-07-2009 20:02 EDT

Dear Dan! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

help

 

100

3 days

10-07-2009 06:40 EDT

I am Interested. Please provide more information.

help

 

50

0 days

10-07-2009 02:58 EDT

Hi. I`m already have similar macros. Alexander.

help

 

45

3 days

10-07-2009 14:38 EDT

I have done such thing before so can do this too easily.

help

 

100

0 days

10-06-2009 20:56 EDT

What excel version do you use? My offer covers Excel 2003, 2007, and 2010. It needs a few hours only.

help

 

40

1 day

10-07-2009 13:50 EDT

As an top expert of vb & vba,I'm looking forward to working with you,see PMB please.

help

 

100

1 day

10-07-2009 00:40 EDT

Please see PMB for details

help

 

69.95

1 day

10-07-2009 05:51 EDT

Greetings Dan from Pennsylvania.. {smile} 1. I noticed in the spreadsheet that routing operations are referred to as '506514-01.OP1', '506514-01.OP2', but in the text file they are referred to as '506514-01.20', '506514-01.30'. Is the OP1, OP2 parlance used in the spreadsheet figurative or literal? In other words, do we only update on an exact match or will some additional matching logic be required (eg. OP1 = lowest operation sequence number found. OP2 = next lowest.)? 2. Which version of Excel will this project be targeted - Excel/2007 or an earlier version? Hello my name is Bill.. I am a VB6, SQL, MsAccess, MsExcel, VBA, VB.Classic, VB.Net, VBScript, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed quite a few GAF projects, so you can find additional references for me here: http://getafreelancer.com/users/feedback_172391.html I have 20+ years of hands-on Programming and Business Information System experience to include many 'shop floor' applications similar to yours. I have a BS in Accounting with a Marketing Minor and graduated college with the highest of honors. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving all of your goals in this endeavor. Respectfully, Bill.

help

 

50

1 day

10-07-2009 03:30 EDT

Please refer to PMB.

help

 

50

1 day

10-07-2009 03:26 EDT

Hello sir. I can provide exactly what you need within one day.

help

 

40

3 days

10-07-2009 06:35 EDT

Hello Please see your PMB for details.

help

 

60

3 days

10-07-2009 15:36 EDT

Ready to do your work. Have a Master's degree in IT and 14 years of experience. Regards, Vladislav

help

 

50

2 days

10-07-2009 10:29 EDT

Hello Dan, Pls check PMB Thanks, Mustafa

help

 

35

1 day

10-07-2009 12:15 EDT

Please check your PMB, thanks

help

 

40

3 days

10-08-2009 06:55 EDT

Please see your PM

help

 

60

3 days

10-07-2009 02:53 EDT

Hi We are available to do the assignment with Excel 2003 VBA within 3 calendar days please.

help

 

150

3 days

10-07-2009 05:00 EDT

Hi, Check PM. Thanks, Sumeet.

help

 

60

3 days

10-07-2009 01:38 EDT

Dear Mr / Ms Please have the kindness to check Project Message Board. Thanks

help

 

185

2 days

10-07-2009 22:58 EDT

Please check PMB. regards

help

 

100

5 days

10-06-2009 22:01 EDT

Hi This is Piyush Patel I have 4.5+ yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Master in Import Export (txt,CSV,Excel) Please Check My PM

help

 

45

1 day

10-07-2009 06:12 EDT

Hi Please Check your PMB..

help

 

100

2 days

10-07-2009 01:12 EDT

Hello I have seen your description in detail as well as attached files. I have ever done some kind of macro programs and I' sure I can help you. Please contact me.I'm ready to start. Thanks.

help

 

40

0 days

10-07-2009 08:33 EDT

Hi, See PMB for demo. Kris

help

 

65

2 days

10-07-2009 16:43 EDT

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

help

 

35

1 day

10-07-2009 15:29 EDT

I have 10 Years of experience in VBA.

help

 

50

1 day

10-07-2009 07:17 EDT

Hi Please see PM. B.R. Zoltan

help

 

40

0 days

10-07-2009 07:35 EDT

It's a daily routine for me, please, see PMB for details! Regards!

help

 

45

1 day

10-07-2009 14:36 EDT

This should be relatively simple. With input/feedback from you we whould be able to accomplish this task in a few hours. My goal is to ensure that you get exactly what you want and what you are paying for!

help

 

100

7 days

10-06-2009 22:18 EDT

(No Feedback Yet)

I can do it.Please inform me when i could start

help

 

60

3 days

10-07-2009 02:24 EDT

(No Feedback Yet)

I'm interesting Your project.10 years experience in VBA (WinAPI, contols, Serial connections RS232 from excel, connections Outlook-Excel, Excel-Word, data mining and operations on the txt files. If You choose my offer please send me email: "danielreclik(at)poczta.fm"

help

 

100

5 days

10-07-2009 02:41 EDT

(No Feedback Yet)

Will provide a professional solution.

help

 

45

0 days

10-07-2009 02:43 EDT

(No Feedback Yet)

Hi, nice and easy, fast though accurate. Thanks. Regards, RobinzonKruzo

help

 

45

1 day

10-07-2009 02:46 EDT

(No Feedback Yet)

Piece of cake. I do this almost daily, with macros that I developed of course. Siddharth, VBA Guru

help

 

30

3 days

10-07-2009 03:20 EDT

(No Feedback Yet)

I am ready to deliver

help

 

35

1 day

10-08-2009 09:58 EDT

(No Feedback Yet)

Check Out My PM For More

help

 

100

2 days

10-07-2009 06:47 EDT

(No Feedback Yet)

Addirtional info.needed: - is it one or multi txt files to be dealt with? - in case it is many txt files should the info. be accumulated in one xls file? - as for discription field. is it stricltly just "-22VTC" to be replaced with .OP*? Sample DATA.txt includes routing without "-22VTC". - are any requirements as for formating fields in xls file?

help

 

100

1 day

10-07-2009 07:29 EDT

(No Feedback Yet)

I'm an active vba programmer would ready to do this job for you.

help

 

60

1 day

10-07-2009 08:41 EDT

(No Feedback Yet)

Excel / VBA Expert with many years experience, including importing / exporting data from .csv, .txt and databases. I can complete this task for you quickly and accurately and am looking forward to working with you. Recent work includes creating excel macros to track changes in a spreadsheet, creation of complex sales tool within excel that maps to word documents and much more besides. Kind regards Chris

help

 

50

3 days

10-07-2009 09:25 EDT

(No Feedback Yet)

Hi, I have analysed the files you posted. The work shall be relatively quick to perform. After it is complete I would need to request extra sets of data to confirm that all your requirements are met and there are no bugs for certain situations not in the sample set provided.

help

 

70

2 days

10-07-2009 10:18 EDT

(No Feedback Yet)

pls check pmb

help

 

60

3 days

10-07-2009 11:54 EDT

(No Feedback Yet)

I had already done similar tool named Data Discover that extract plan information from text file to excel for Hartford client. So i hope the similar task is yours and i am willing to do that. Thanks Arul

help

 

65

2 days

10-07-2009 12:38 EDT

(No Feedback Yet)

I am a new user try to make a little extra money to make ends meet. I work as a accounting assistant therfore I am very accurate and familiar with excel and data entry. I look forward to working with you.

help

 

50

1 day

10-07-2009 13:36 EDT

(No Feedback Yet)

Please Visit PMB...

help

 

50

1 day

10-07-2009 14:58 EDT

(No Feedback Yet)

I have created numerous macros & i can deliver this solution within a day.

help

 

45

3 days

10-07-2009 16:11 EDT

(No Feedback Yet)

I have 7 years of experience working with Excel and VBA.

help

 

45

1 day

10-07-2009 18:09 EDT

(No Feedback Yet)

I think that most of these guys are just talkers, Dan. See screenshot of your sample data in PMB. Needs another couple of hours to meet all reqts. California-based provider. Jim

help

 

50

0 days

10-07-2009 20:05 EDT

(No Feedback Yet)

I'm an Industrial engineer and I working for Triumph Aerospace System, on the Engineering Department, I develop project of automation for our clients like Boeing, Airbus, Brice Aerospace. I working with Time Standar, Bill of Materias, MRP, and others reports, please see my post for view a solution for your project. Thanks and Best Regards Eng. Zeus Alberto Paez Renteria

help

 

40

0 days

10-08-2009 06:27 EDT

(No Feedback Yet)

Please check PM!

help

 

40

0 days

10-08-2009 12:45 EDT

(No Feedback Yet)

Fluent in VB and VBA scripting. Have done extensive Excel macros. I can do your requirement very easily in a couple of hours time.

help


    Bid on this Project