进行中

Build VBA model from existing excel spreadsheet

We are a woodware manufacturer in New Zealand and we focus on making ethnic flavoured giftware for the New Zealand souvenir market (see [login to view URL])

We have been in business for over 25 years and use a custom built excel spreadsheet to calculate initial and ongoing product costs and to assist with the setting of sell prices.

Our business has grown from 20 odd products to over 180 products and the spreadsheet is now cumbersome, easy to “corrupt” and difficult to navigate.

We seek a VBA expert to re-write our software to correct the above issues. ie standardised entry forms for stock, standard template for new product entry, time trial database & linking, labour cost analysis, projected profit analysis per item, ability to create components as stock items, linked navigation, etc.

As the spreadsheet is of an extremely commercially sensitive nature, I am reluctant to attach it here where anybody can access it. Instead I have attached some snapshots of the various portions to give you an over-view of the spreadsheet we wish to automate.

Please respond with why I should select you, your confidentiality agreement, hourly rate and cost estimate to complete this project (to the nearest NZD$250). I will shortlist likely candidates based on this response.

技能: 数据处理, Excel, 微软Access, Visual Basic, Visual Basic的应用程式

查看更多: excel vba create new workbook and name it, excel vba create new workbook with one sheet, create new workbook vba, vba add worksheet to end, excel vba create new workbook and copy data, excel vba copy worksheet to existing worksheet, excel vba add worksheet before first sheet, excel vba create new workbook from template, excel spreadsheet vba data entry form, can build front end excel spreadsheet, vba excel spreadsheet work, access vba open format excel spreadsheet, vba front end excel spreadsheet, automatically email excel spreadsheet vba, vba excel spreadsheet, lock items excel spreadsheet, custom excel spreadsheet model jobs, access vba manipulate excel spreadsheet, excel spreadsheet sir model, excel spreadsheet sir epidemic model

关于此雇主:
( 0个评论 ) Rotorua, New Zealand

项目ID: #18097140

授予:

Walshie1987

Hi, I'm Chris from the UK and this is the sort of project that I love doing! I've not only had over 10years experience in excel and VBA, but my job is to apply this logic in a manufacturing environment - I work for a d 更多

$1200 NZD 在10天内
(9条评论)
4.7

45 威客就此工作平均出价 $1032

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( 更多

$777 NZD 在5天内
(654条评论)
8.3
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Build VBA model from existing excel spreadsheet. I can assure you the quality job. I have good experience in Data Processing, Excel, Microsof 更多

$750 NZD 在6天内
(305条评论)
7.7
branislavm

Hi! I wonder - do not you want to move this to the real database? Excel is good as a spreadsheet but quite poor as a database as you noted. Personally, I think if you move forward with Excel the things will complica 更多

$1250 NZD 在20天内
(204条评论)
6.9
cugamelover

I read your requirements carefully and I confirm that I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in VBA programming for Excel. I've developed many sim 更多

$1000 NZD 在10天内
(197条评论)
7.2
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As 更多

$833 NZD 在20天内
(90条评论)
7.4
paris2785

Hello! My name is Paris. According to your brief, you need a developer that will elaborate your existing Excel spreadsheet. I will write the required VBA code that will automate the functionality, and turn your spre 更多

$1200 NZD 在14天内
(210条评论)
7.1
zekovicm

Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th 更多

$1250 NZD 在20天内
(96条评论)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. You must choose me because i am VBA Top freelancer and i 更多

$1250 NZD 在10天内
(217条评论)
6.9
polarjin2017

Hello? How are you? I have good experiences in "Build VBA model from existing excel spreadsheet" as you can see my profile for these (Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps). I 更多

$800 NZD 在3天内
(69条评论)
6.4
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Well. I have delivered similar solutions already, and can deliver this for yo 更多

$1000 NZD 在10天内
(72条评论)
5.9
royalcalif

My suggestion for your requirement is MS Access. We will create a application using MS Access with VB Script. It will fulfilled your all requirements. I wish to discuss more about the workflow, Process behind the data 更多

$750 NZD 在20天内
(103条评论)
6.1
expertcoder1vw

Hi, I read your project with interest and am pleased to make my best bid for developing a database to manage your business operations. Based on the information provided, this needs to be developed as an Access data 更多

$1500 NZD 在28天内
(41条评论)
5.7
kevivu

Hourly Rate: 20NZD Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, 更多

$750 NZD 在10天内
(75条评论)
5.9
fuentro

Hi, my name is Rodrigo. I believe I can help you out with this project, as a matter of a fact the reason why I think you should select me is because I could make an entire system based on your specifications in .NET wh 更多

$1111 NZD 在10天内
(29条评论)
6.0
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards PS : Let's discuss further. I can also offer a solution as proper window application 更多

$800 NZD 在20天内
(58条评论)
5.7
katiewells3

I would love the opportunity to chat with you further about your project, as it would be great to get an idea of the scope of the workbook (I can see from the time trial collection there are quite a few tabs)? Howev 更多

$1500 NZD 在15天内
(25条评论)
4.9
gr8tech

Hello there, I have gone through your project description. **For a confidentiality agreement, freelancer has an option to add an NDA to a project and you should add that to your bid, which I will confirm. **The cos 更多

$1250 NZD 在15天内
(37条评论)
5.0
crypthne

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert 更多

$750 NZD 在10天内
(36条评论)
4.8
scorpionobaid01

Hi I am here to assist u inthis project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experience and have great skill 更多

$750 NZD 在10天内
(22条评论)
4.2
vijayvizzu7

Hi, you had selected a project cost between NZD 750-1500 and in your project description you mentioned nearly NZD 250. I am ready to make this project at NZD 250. I have 10+ years of experience in Advance Excel, VBA, M 更多

$750 NZD 在10天内
(10条评论)
4.2