Käynnissä

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

Taidot: tiedonsyöttö, tietojenkäsittely, Visual Basic, Windows Desktop

Näytä lisää: 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

Tietoa työnantajasta:
( 10 arvostelua ) Hawley, United Kingdom

Projektin tunnus: #194248

Myönnetty käyttäjälle:

xamdam91

Looking forward to working with you

150 $ USD 1 päivässä
(65 arvostelua)
6.2

36 freelanceria on tarjonnut keskimäärin 164 $ tähän työhön

schandraram

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

200 $ USD 4 päivässä
(102 arvostelua)
6.6
svet63

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

100 $ USD 1 päivässä
(60 arvostelua)
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 Lisää

100 $ USD 0 päivässä
(15 arvostelua)
5.9
pentium10

Professional work from professionals!

299.99 $ USD 10 päivässä
(31 arvostelua)
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 Lisää

289.95 $ USD 2 päivässä
(26 arvostelua)
5.4
rajanlengde

I can do it well. SEE PMB

100 $ USD 3 päivässä
(31 arvostelua)
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 2 päivässä
(16 arvostelua)
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 Lisää

135 $ USD 1 päivässä
(9 arvostelua)
4.1
rajhansh

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

250 $ USD 5 päivässä
(16 arvostelua)
4.1
rudyos

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

100 $ USD 2 päivässä
(6 arvostelua)
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 1 päivässä
(7 arvostelua)
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 Lisää

150 $ USD 3 päivässä
(7 arvostelua)
3.6
pinoywebdev

Please read message in PMB for details

250 $ USD 5 päivässä
(3 arvostelua)
3.0
sensetech

Please see PM for details

140 $ USD 3 päivässä
(1 arvostelu)
2.7
TechnoVilla

plz check pmb

100 $ USD 7 päivässä
(1 arvostelu)
2.5
OliverSDaniel

Please send sample as early as possible

125 $ USD 5 päivässä
(1 arvostelu)
1.4
alekseymihalych

Hi With part 2 Regards

170 $ USD 7 päivässä
(4 arvostelua)
1.3
dren

hello it can be done.

250 $ USD 2 päivässä
(1 arvostelu)
1.2
vijay2404

please see pmb for details

250 $ USD 5 päivässä
(0 arvostelua)
0.0
aditya95

it can be done.

125 $ USD 6 päivässä
(0 arvostelua)
0.0