In Progress

Worksheet and Database in Excel


- Create program in Excel where we can paste data in one page.

- Excel should pick up pricing from another tab.

- Create pricing table with multiple columns and rows

- Separate table for each customer.

- One default table

- Write formula and calculate price for work done

- Output to another tab with existing template for invoice.

- Print Invoice

- Calculate employees commission

- Output to another tab employee commission and statement of work done

- Track all the work done and pricing for each work done, employee payout and Invoice in separate database.

Skills: Excel, Visual Basic, Data Processing, Microsoft Access, Software Architecture

See more: create excel form template quickbook import, create template letters database, vba write formula excel vba, php excel create worksheet, create excel database will create letters word template, create excel report template, create excel file template, excel create database invoice, access database design create reports excel, excel create database summary table, create template excel mysql, excel inventory template create, create excel survey template, create simple excel spreadsheet template macros, excel create formula will subtract total stock cell, create template slides excel, advanced formulas and functions in excel 2007, how to compute late and undertime in excel, list of countries and states in excel

About the Employer:
( 5 reviews ) 14 UNGAVA BAY RD., Canada

Project ID: #21235140

38 freelancers are bidding on average $84 for this job


Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many More

$80 CAD in 7 days
(40 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$100 CAD in 2 days
(437 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 CAD in 3 days
(432 Reviews)

Hey there ! I specialize in Excel and Excel Program Building. I would love to help you out with this project. I am a good Virtual Assistant,Data Researcher,Data Entry Operator,Data Scraper,Great with Excel and Word a More

$100 CAD in 2 days
(52 Reviews)

I can develop an excel based automated tool, to calculate pricing, creating invoices, calculating commissions, creating a database to store all work done, invoices and commissions. lets discuss this in detail in chat o More

$300 CAD in 5 days
(43 Reviews)

Hi, there I hope all's well with you. I can code that using SQL/ADO coding within Excel. I'll detail in private chat. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for More

$200 CAD in 7 days
(62 Reviews)

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

$77 CAD in 3 days
(65 Reviews)

Hi, I have gone through with your requirements and I would like to suggest you to create MS Access database for this. MS Access relational database would be perfect for this. Please ping me discuss in detail. I will d More

$250 CAD in 7 days
(28 Reviews)

Hi, What would you prepare through Macro or Excel function? Relevant Skills and Experience VBA and advance excel

$55 CAD in 2 days
(25 Reviews)

Hi, I develop such Excel file for you with VBA programming in it, please take look at my profile portfolio, those are all Excels which has Database in it and doing complex tasks by using VBA

$200 CAD in 6 days
(14 Reviews)

I can do the job! Do you have an excel template you are using or should I start from cero? About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including i More

$60 CAD in 5 days
(25 Reviews)

Hi, do you have already your concept? or maybe the raw data (to be processed)..???? I'm an excel expert. For your project, I think it will be done with Macro VBA, it will be easier for you to use. I'll show you once yo More

$50 CAD in 4 days
(46 Reviews)

Hello There, I am an experienced virtual assistant having 11 years of work experience. I am interested, please feel free to contact to discuss further on the project. 

$65 CAD in 7 days
(6 Reviews)

Hi there, I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel report design, but can do most tasks needed in excel. I have a solid understanding of accounting More

$100 CAD in 7 days
(10 Reviews)

Sir, I have 5 years of experience in this relevant task. I am a professional freelancer. I will do your task within your budget. So you can select me as the right freelancer. Please hire me. Thanks

$50 CAD in 3 days
(15 Reviews)

I'm very interested in getting your work done. I feel confident to complete it according to your requirements because I have more than 3 years’ experience in compiling data in spreadsheet. I have gone through the proje More

$70 CAD in 1 day
(5 Reviews)

Please share the requirement .Expect periodic updates .Please trust and give a chance will not disappoint [login to view URL] message me for the requirements.

$30 CAD in 1 day
(6 Reviews)

Hello, My name is Waseem, I'm expert in MS Excel, Access and VBA and have more than 10 years experience in building and developing MS Access Applications. I would like to help you in your project and I'm ready to sta More

$60 CAD in 7 days
(7 Reviews)

Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and Mobile development using ASP.Net, C#, SQL server, Xamarin, WebAPI, VB6 More

$65 CAD in 7 days
(7 Reviews)

Hi, i am interested in clean development of this project as i am an experienced excel programmer and have done lots of projects

$100 CAD in 10 days
(6 Reviews)