Lukket

Excel/Visual Basic Macro project

I have a large Visual Basic/Excel and Database project that requires maintenance over a period of 3 months.

The project requires that someone is able to add to, delete, query and program the Microsoft Excel and Microsoft SQL database as needed. Some VB macros will also needed to be created. The project requires familiarity with all the Microsoft Word family of products.

I would imagine the project will take up 20 hours per week for 3 months. The project pays £1,500 per month.

The person selected for this project will be done so on the basis of their skill. To proceed further with this, we require the applicant to come up with a quick solution to the problem below. This will prove that you are able to work well with our systems.

Problem: There are 2 worksheets in Excel. Worksheet A and worksheet B. Worksheet A has a list of all customers and new customers are added to this worksheet all the time. Whereas worksheet B is a database of all customers. But all old customers that are no longer with us are deleted from Worksheet B. Please come up with a quick Macro using Visual Basic that copies lists of customers from worksheet A to worksheet B. But where there is a 0 in the field of worksheet B (where old customer details were kept - the ones that have been deleted), we require customers' details from worksheet A to be added to this available space.

The simplest and most elegant solutions to this problem will be considered for this temporary post. Thank you.

Færdigheder: Excel, Visual Basic

Se mere: we excel, excel macro to word, excel &, programmer excel visual basic access programming, macro project bid, garments project, sample macro projects, vb in excel, skill list, new excel, n excel, microsoft visual, microsoft macro, macro microsoft word, add up work hours, customer database in excel, visual, Visual Basic Excel, visual b, vb excel, sql project , project solutions, project done most, macro, macro excel

Om arbejdsgiveren:
( 0 bedømmelser ) Frimley, United Kingdom

Projekt-ID: #289050

51 freelancere byder i gennemsnit $3473 for dette job

simonchen

Plz check PM. Thanks.

$3000 USD in 10 dage
(11 bedømmelser)
5.1
sikandermandal

Please See PMB.

$5000 USD in 30 dage
(4 bedømmelser)
4.3
alexitkin

Please provide example spreadsheets A and B with data. Why leave zero records in B - delete them once and add new at the end. If you mean just sign them deleted and repair when you again contacting them what is the Mere

$3000 USD på 1 dag
(17 bedømmelser)
3.8
mcgrogan40

Hi, I have 10 years experience in international financial application development using VBA/SQL - I would like to add 3 months to that ;)

$3600 USD in 90 dage
(5 bedømmelser)
2.8
anhhn

Please see PM for more information. Thank you

$3000 USD in 20 dage
(1 bedømmelse)
2.8
excelinnovation

Hi, based in UK - please see PMB. Regards

$3000 USD in 90 dage
(7 bedømmelser)
2.7
maximus91

Looking forward to working with you.

$3000 USD in 90 dage
(1 bedømmelse)
2.2
megsoft

Please see your PMB

$4500 USD in 90 dage
(2 bedømmelser)
1.9
raghavmp17

I have 8 yrs of experience in Excel, VBA, VB6, MS SQL, ORACLE. I can complete your task within time line.

$3000 USD in 5 dage
(1 bedømmelse)
0.7
swamytalam

I have been working with Excel Macors and VB script since 2.5 years. I can do it very fast. Please send me the contact details, so that i can send you the Excel with buttons to add and delete customers from sheetA Mere

$3500 USD in 45 dage
(0 bedømmelser)
0.0
jeffh25

$3000 for programing over a 30 day period to your specifications. I have a macro which performs exactly what you requested in about 20 to 30 lines of code. I can send this to you so you can run the macro for yourself. Mere

$3000 USD in 30 dage
(0 bedømmelser)
0.0
mansari11

I doubt you would find a more elegant solution than the one I have for you. It is fancy fully automated menu driven solution. Please check the PMB for the sample. Due to my high bidding price, you may not accept this b Mere

$15000 USD in 90 dage
(0 bedømmelser)
0.0
dg100

hey let me try doing this. i have been handling vb codes for 4 years now. tnx

$3000 USD in 7 dage
(0 bedømmelser)
0.0
legolassoi

Check PM - fast working macro

$3000 USD in 30 dage
(0 bedømmelser)
0.0
basilis

Job satisfaction guaranteed. Fully detailed code will be delivered. Looking for future cooperation, as well.

$3000 USD in 90 dage
(0 bedømmelser)
0.0
scristori

I have more than 9 years of experience developing applications. I'm ready to start the job.

$3000 USD in 90 dage
(0 bedømmelser)
0.0
VIGroups

Hello Sir/madam, We have made the Excel file as per your [url removed, login to view] have written the macro in VB and it works exactly the way you have put in the [url removed, login to view] are ready to provide the Excel file anytim Mere

$3000 USD in 21 dage
(0 bedømmelser)
0.0
msshekhawat

i have the exerience in the developement in visual [url removed, login to view] have the capability to complete it within time.

$3000 USD in 15 dage
(0 bedømmelser)
0.0
zhg

Please see PMB and attached sample VBA macro.

$3000 USD in 30 dage
(0 bedømmelser)
0.0
cyBuzz

well, need clarification.

$3000 USD in 90 dage
(0 bedømmelser)
0.0