Find Jobs
Hire Freelancers

Database and Excel Project

$250-750 USD

Completed
Posted over 13 years ago

$250-750 USD

Paid on delivery
I need all the boxes in blue entered into the database when I press the "Enter Order" button on the Billing sheet. It will basically enter all the customer data, and their order information to the DB. The flow works like this. The sales rep. in the field takes the order on the Excel. They email the order into the main office where it is reviewed, once approved the "Enter Order" button is pushed and this sends all the blue boxes data into the DB. Many of these fields do not exist in the DB, and will have to be created and linked. The styles are in the DB and the Excel looks them up, so the DB will need these linked. Quite a bit of work to be done in the DB as you will see. Also I need a macro written that will unhide the bar codes at the bottom of "Shell, Braid 1, Braid 2, Braid 3, Braid 4, Waistband, Collar, Letter1, Letter 2, Letter 3, Lettering 4, Lettering 5, and unhide sheet AP". It will also remove inventory from the DB based on the numbers from the "AP sheet". Please enter some styles and notice how the options change based on selections, you will get a feel for it and see the related fields the data comes from in the DB, and then you will understand the relations, and what I need to go back to the DB. I would be happy to set up a Web Ex to go over the project in more depth. Need to be expert level with excel, access, and VBA. I have included the bar code font if you want to see the bar codes on the second page.
Project ID: 920853

About the project

42 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have reviewed the spreadsheet and database. I've determined it would take me about 4 days to complete. I will need to know the version of Microsoft Office that you're using so that I don't use a newer version when compiling the code. I have over 7 years experience creating customized Microsoft Office VBA solutions that allow data exchange between Access, Excel, Outlook, Powerpoint and Word.
$480 USD in 4 days
5.0 (1 review)
3.4
3.4
42 freelancers are bidding on average $436 USD for this job
User Avatar
HI, I m expert in analysis/desgin and VBA of Access and Excel. plz check my profile. I m ready to have online session(s) with u before i start development. and i ll keep u updated with my progress at each day of work. Hussien Sharaf
$900 USD in 7 days
5.0 (61 reviews)
6.6
6.6
User Avatar
Hello - Please see PMB for details of my bid. Thank you. Chandra Ram
$650 USD in 10 days
4.8 (116 reviews)
6.6
6.6
User Avatar
Please see PMB
$625 USD in 5 days
5.0 (103 reviews)
5.8
5.8
User Avatar
Hi, I have more 10 years experience in MS Access and MS Excel automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex
$500 USD in 3 days
4.9 (35 reviews)
5.6
5.6
User Avatar
I can deliver the same
$400 USD in 5 days
4.9 (30 reviews)
5.6
5.6
User Avatar
Hello Ready to start right now. Please see your PMB for details. Thanks
$250 USD in 10 days
4.9 (31 reviews)
4.8
4.8
User Avatar
Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Looking forward to your prompt reply. Kindest regards. Farrukh Rehman.
$500 USD in 3 days
4.7 (19 reviews)
4.5
4.5
User Avatar
Please see PM for details. Thanks.
$750 USD in 10 days
5.0 (14 reviews)
4.4
4.4
User Avatar
Hello, see PM for details.
$250 USD in 8 days
5.0 (9 reviews)
3.2
3.2
User Avatar
Hi! I am a certified accountant and using Ms Excel is what I love to do. It's more than 6 years I have been using this Microsoft tool and have developed an accounting Software in Excel as well. Just send me the file and get it done with LOWEST turn around time at MINIMUM price with BEST quality. Thanks
$400 USD in 5 days
5.0 (1 review)
1.5
1.5
User Avatar
i give you guarantee if there are the mistakes in
$750 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can Produce this Project. Please See PM for Details
$700 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I'll start by saying that I do this kind of applications in my day job on a daily basis. Looking forward to your replay. Have a nice day.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, We are interested. We are ready to start now. You can expect a professional Touch from Us. Thanks.
$350 USD in 15 days
0.0 (0 reviews)
1.0
1.0
User Avatar
this bid will include all the expenses for the project and the internet usage.
$485 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am from India, working with windows, sql server, access, vb6, vb.net,C, C#, Crystal Reports, foxpro since 1994, I have developed many projects like inventory, accounting, payroll, hotel management, School Fees Collection System, ERP solutions running successfully at many locations. Also providing hardware and networking support. I will give u exact solution to fulfil ur requirement.
$500 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
eSync is team of professional have enough expertise to provide state of art technology base solutions to its client. The core objective of eSync is to deliver Cost Effective, Efficient & Result Oriented Solutions to its clients
$300 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, Please check your PMB Details. Thanks & Regards, SevenStar Infotech.
$550 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this get me information
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Am a excel trainer for company people and working as the same field so i can able to work your project in an excel sheet with clearly pivot table and sorting wise. If you are interested kindly get back to me.
$250 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
MOUNTAIN VEIW, United States
4.9
10
Payment method verified
Member since Dec 2, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.