Suoritettu

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

35 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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
schandraram

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

$200 USD 4 päivässä
(76 arvostelua)
6.5
pentium10

Professional work from professionals!

$299.99 USD 10 päivässä
(31 arvostelua)
5.5
rajanlengde

I can do it well. SEE PMB

$100 USD 3 päivässä
(33 arvostelua)
5.3
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ä
(14 arvostelua)
5.9
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
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ä
(17 arvostelua)
4.3
rudyos

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

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

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

$250 USD 5 päivässä
(14 arvostelua)
3.6
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
pinoywebdev

Please read message in PMB for details

$250 USD 5 päivässä
(3 arvostelua)
3.4
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
dren

hello it can be done.

$250 USD 2 päivässä
(1 arvostelu)
1.2
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ä
(3 arvostelua)
0.5
zartashia

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.

$100 USD 10 päivässä
(0 arvostelua)
0.0
esiege

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.

$100 USD 1 päivässä
(0 arvostelua)
0.0
aditya95

it can be done.

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