In Progress

Excel Work required / VB code

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

Skills: Data Entry, Data Processing, Visual Basic, Windows Desktop

See more: invoice log excel solution, we excel, vb work, vb this, project quote sample, first code, excel &, code get, project code excel, sudoku excel expert vba, bid excel workers, code samples invoice, excel code vbs vba data base, code invoice numbering excel, invoice excel vba, sudoku code visual basic, excel code work application, visual basics code names number days worked, hello work, invoice number, online excel work bidding, excel work bid, excel database codes project, invoice number plus macro excel, code excel compare work

About the Employer:
( 10 reviews ) Hawley, United Kingdom

Project ID: #194248

Awarded to:

xamdam91

Looking forward to working with you

$150 USD in 1 day
(65 Reviews)
6.2

36 freelancers are bidding on average $164 for this job

schandraram

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

$200 USD in 4 days
(102 Reviews)
6.6
svet63

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

$100 USD in 1 day
(60 Reviews)
6.4
riyoyo

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 More

$100 USD in 0 days
(15 Reviews)
5.9
pentium10

Professional work from professionals!

$299.99 USD in 10 days
(31 Reviews)
5.5
wsh2

"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 [url removed, login to view] and www.experts-exchan More

$289.95 USD in 2 days
(26 Reviews)
5.4
rajanlengde

I can do it well. SEE PMB

$100 USD in 3 days
(31 Reviews)
5.2
johnsinit

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.

$100 USD in 2 days
(16 Reviews)
4.3
Nirmal2006

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, AD More

$135 USD in 1 day
(9 Reviews)
4.1
rajhansh

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

$250 USD in 5 days
(16 Reviews)
4.1
rudyos

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

$100 USD in 2 days
(6 Reviews)
3.9
uniiversesoft

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.

$275 USD in 1 day
(7 Reviews)
3.6
guolibin

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. Than More

$150 USD in 3 days
(7 Reviews)
3.6
pinoywebdev

Please read message in PMB for details

$250 USD in 5 days
(3 Reviews)
3.0
sensetech

Please see PM for details

$140 USD in 3 days
(1 Review)
2.7
TechnoVilla

plz check pmb

$100 USD in 7 days
(1 Review)
2.5
OliverSDaniel

Please send sample as early as possible

$125 USD in 5 days
(1 Review)
1.4
alekseymihalych

Hi With part 2 Regards

$170 USD in 7 days
(4 Reviews)
1.3
dren

hello it can be done.

$250 USD in 2 days
(1 Review)
1.2
vijay2404

please see pmb for details

$250 USD in 5 days
(0 Reviews)
0.0
aditya95

it can be done.

$125 USD in 6 days
(0 Reviews)
0.0