Project Detail

Excel Work required / VB code  

Excel Work required / VB code is project number 194248
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: xamdam91

Budget: $100-300

Created: 11/10/2007 at 9:59 EST

Bid Count: 36

Average Bid:
$ 164

11/11/2007 at 9:59 EST

Project Creator: pelicanhelpdesk
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (7 reviews)

Bid On This Project
 

Description

We currently run several excel spread sheets
one is a log of invoice numbers with describtion and value

the other are the detailed invoices
we need a macro that when in the detail invoice and a macro button is pressed to get the inv number
it opens the invoice log spreadsheet
finds the last invoice number adds one and copies that number into the invoice detail spread sheet,
then the value, ref and customer name is copied to the invoice log

they are seperate spreadsheets and should check if the invoice log is already open if so returns a message saying unable to allocate invoice number

Please quote on above this is the urgent requirment

this would be first step in the project the next would be to move the invoicelog to a database and have the detail excel spread get the number from the database and a basic VB form to allow manually entires into the invoice log

please also quote on doing part 2 if you feel it ca be done .

sample of both spreadsheets will be given when required

thanks

Richard

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

 

299.99

10 days

11-10-2007 15:40 EST

Professional work from professionals!

help

 

150

1 day

11-10-2007 14:35 EST

Looking forward to working with you

help

 

250

5 days

11-10-2007 16:02 EST

Please read message in PMB for details

help

 

100

7 days

11-10-2007 21:34 EST

plz check pmb

help

 

135

1 day

11-11-2007 02:15 EST

Dear Sir, I am having 4+ years sound experience in the field of web site development and designing. My toolset includes asp/asp.net (framework 2.0), sql server 2000/2005, ms access, C#/VB.Net, Visual Basic 6.0, VBA, ADO and AJAX. I can develope required macro within a day. Willing to start right now !!... Waiting for your reply - Nirmal.

help

 

100

1 day

11-11-2007 04:59 EST

Excel VBA developer since 1997. Can do second part, too. Another $100. Regards, Svet

help

 

100

2 days

11-11-2007 00:33 EST

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

help

 

100

3 days

11-10-2007 13:29 EST

I can do it well. SEE PMB

help

 

100

0 days

11-10-2007 10:15 EST

These can be solved in just 30 minutes, using Excel VBA/Macro code. Although, we dont need to show the second worksheets, as Excel is able to hide them but we are still able to retrieve a cell's value. So, please give me more detail, but I am ready to start it right way. regards, Ryoyo

help

 

289.95

2 days

11-10-2007 13:52 EST

"Branching out from the log". Hello my name is Bill.. I am a VB.Net, VB, VBA, SQL, MsAccess, MsExcel, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed several GAF projects, so you can find additional references for me here: http://elance.com/users/feedback_172391.html I have 20+ years of hands-on Programming and Business Information System experience. I have a BS in Accounting / Marketing Minor; graduating 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 your every endeavor. Respectfully, Bill.

help

 

200

4 days

11-11-2007 02:31 EST

Hello Please see PMB for details of my bid. Thank you.

help

 

250

2 days

11-10-2007 10:17 EST

hello it can be done.

help

 

150

3 days

11-10-2007 10:10 EST

Hello I can do the work for you. About the part 2,of course it can be done. But what database would you use? If you would like to choose my bid or have questions please tell me and send me the sample. Thanks. Look forward to work with you. :) Best regards.

help

 

275

1 day

11-10-2007 23:12 EST

Dear sir, Greetings!!! We are ready to do this job right now. Please refer PM for further details. Thanks. Regards, Shrinivas.P.,Uniiverse Soft Tech, India.

help

 

125

5 days

11-10-2007 19:54 EST

Please send sample as early as possible

help

 

100

2 days

11-10-2007 21:15 EST

I'm very interested in your project, please check PMB

help

 

140

3 days

11-10-2007 11:44 EST

Please see PM for details

help

 

250

5 days

11-10-2007 12:03 EST

(No Feedback Yet)

please see pmb for details

help

 

100

10 days

11-10-2007 12:06 EST

(No Feedback Yet)

I am new but i can do an excellent job for you and that i will do it for the lowest price that you wants to pay for the project.

help

 

100

1 day

11-10-2007 12:52 EST

(No Feedback Yet)

Something that I do on a regular basis for my own business. It can also be done through a pop-up userform, so only relevant information is displayed.

help

 

100

1 day

11-10-2007 13:11 EST

(No Feedback Yet)

i have 10 years experience in developing macros and plugins for ms-word and excel. i have vast experience in VB forms and database applications. about the second stage: as it is a lot simpler application then programming an excel macro: my price for this application is 50 USD.

help

 

300

3 days

11-10-2007 13:12 EST

(No Feedback Yet)

Both parts could easily be done. I have done work for Bank of America, GM, Caterpillar and others. VBA is my specialty.

help

 

200

4 days

11-10-2007 13:23 EST

(No Feedback Yet)

I am expert in Excel and VB. I can do the job.

help

 

265

15 days

11-10-2007 13:53 EST

(No Feedback Yet)

Write me to discuss this in detail...

help

 

100

2 days

11-10-2007 14:26 EST

(No Feedback Yet)

Hi, This seems a fairly trivial task, and one with which I'm extremely familiar, having coded similar functionality on several occasions. I've seven years experience of writing large business applications with Excel/VBA coding plus Access for my last employer. I've now retired and am looking for tasks like these as a welcome change to Sudoku day in day out :-) The second part of your task is a natural follow on and again seems fairly straightforward. I'm busy on Monday (UK time) and have quoted 2 days to allow for time differences. Regards, Richard

help

 

170

7 days

11-10-2007 14:33 EST

(No Feedback Yet)

Hi With part 2 Regards

help

 

100

2 days

11-10-2007 15:15 EST

(No Feedback Yet)

I have prior experience in excel automation using scripts. Looking forward for a fruitful and fulfilling work.

help

 

100

0 days

11-10-2007 15:25 EST

(No Feedback Yet)

i can do this jop with 8 hour . Contact me please, thanx

help

 

100

2 days

11-10-2007 15:34 EST

(No Feedback Yet)

Hi My name is sandro The job can be done. Thanks

help

 

225

3 days

11-10-2007 16:10 EST

(No Feedback Yet)

Good day. I have done over a dozen Excel/VBA programs for multi-file look ups programs for various clients in the manufacturing MRO area. I have sent you a PM to clarify your project scope.

help

 

140

1 day

11-10-2007 16:29 EST

(No Feedback Yet)

I can help you on both projects, it should be no problem to implement the excel solution. Even the same excel can be used (as GUI) with a database to save the data in a more reliable way without having to implement all of the GUI using just VB

help

 

100

7 days

11-10-2007 16:54 EST

(No Feedback Yet)

hi. check pmb thanks.

help

 

150

1 day

11-10-2007 22:56 EST

(No Feedback Yet)

Professional and quick. Results and delivery guaranteed. Looking forward to working with you.

help

 

150

4 days

11-10-2007 23:44 EST

(No Feedback Yet)

we can do the two part in 4 days

help

 

125

6 days

11-11-2007 01:31 EST

(No Feedback Yet)

it can be done.

help

 

250

5 days

11-11-2007 04:00 EST

(No Feedback Yet)

I have a similar kind of project. If u are interested please pm me.

help


    Bid on this Project