Excel/Visual Basic Macro project

Closed

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.

Skills: Excel, Visual Basic

See more: 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

Project ID: #289050

51 freelancers are bidding on average $3473 for this job

simonchen

Plz check PM. Thanks.

$3000 USD in 10 days
(11 Reviews)
5.1
sikandermandal

Please See PMB.

$5000 USD in 30 days
(4 Reviews)
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 More

$3000 USD in 1 day
(17 Reviews)
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 days
(5 Reviews)
2.8
anhhn

Please see PM for more information. Thank you

$3000 USD in 20 days
(1 Review)
2.8
excelinnovation

Hi, based in UK - please see PMB. Regards

$3000 USD in 90 days
(7 Reviews)
2.7
maximus91

Looking forward to working with you.

$3000 USD in 90 days
(1 Review)
2.2
megsoft

Please see your PMB

$4500 USD in 90 days
(2 Reviews)
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 days
(1 Review)
0.7
VIGroups

Hello Sir/madam, We have made the Excel file as per your requirement.We have written the macro in VB and it works exactly the way you have put in the problem.We are ready to provide the Excel file anytim More

$3000 USD in 21 days
(0 Reviews)
0.0
zhg

Please see PMB and attached sample VBA macro.

$3000 USD in 30 days
(0 Reviews)
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. More

$3000 USD in 30 days
(0 Reviews)
0.0
basilis

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

$3000 USD in 90 days
(0 Reviews)
0.0
chongsa

I have experienced on this. Please look at my PM. I am also attaching the Macro/VBA sample that you requested. Thanks.

$3000 USD in 10 days
(0 Reviews)
0.0
dg100

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

$3000 USD in 7 days
(0 Reviews)
0.0
legolassoi

Check PM - fast working macro

$3000 USD in 30 days
(0 Reviews)
0.0
msshekhawat

i have the exerience in the developement in visual basic.and have the capability to complete it within time.

$3000 USD in 15 days
(0 Reviews)
0.0
scristori

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

$3000 USD in 90 days
(0 Reviews)
0.0
Arvindmangal2002

Dear Sir, I want to say you very frankly that i am new to this site. But i want to confirm you that we are having a very good experience in VB 6.0 and Access or excel. So personally i feel so that this More

$3000 USD in 7 days
(0 Reviews)
0.0
abu2002

plz reffer PMB for sample

$3000 USD in 90 days
(0 Reviews)
0.0