Do some Excel Work

Completed Posted Jul 13, 2015 Paid on delivery
Completed Paid on delivery

Hi there

We are a small, but highly successful bathroom renovation company based in Melbourne.

Due to the large variation in bathroom renovation works we have set up an Excel workbook which allows us to create very detailed quotations. However, this is still extremely time-consuming and with so many quotes to produce we need to keep on top of demand.

We are looking for someone who can either:

a) Extend on the limited drop down boxes we have for each area of work. At the moment, we can only fit 8 lines in the drop down and this needs extending to fit the list in to one view-able section without having to point the cursor and drag down.

or (our preference)

b) create an easily editable spreadsheet (based on our own and using the data already inputted) that can be created whilst at the customer's home discussing the details of the job. Ideally this would allow the estimator to select all works required etc from a master sheet (which encompasses all options) then generate the quote document pulling out just those selected items. A price would be added after, as costings can not be matched to these jobs specifically, so ideally the database would work off the master, be able to highlight/select the relevant items for that job, then pull them out together to create a quote.

Hope someone is interested and can help us please?

Out current quote spreadsheet is attached for your perusal and use.

Many thanks

Alexandra

Data Entry Data Processing Excel

Project ID: #8058599

About the project

35 proposals Remote project Active Aug 2, 2015

Awarded to:

aarifakhtar

Hi: I have a suggestion: Instead of having limited drop-down for each area of work, we can design the quote as a process. The program can just take the user one-by-one through each area of work. This will allow greater More

$200 AUD in 5 days
(67 Reviews)
5.9

35 freelancers are bidding on average $136 for this job

Teloquence

Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation

$221 AUD in 2 days
(296 Reviews)
7.4
zExcel

Hi, I'll be happy to help you with this project. I have plenty of experience in all aspects of Microsoft Excel, especially in developing custom functions and macros. I can do the job real quickly. Please feel free More

$170 AUD in 3 days
(196 Reviews)
7.2
funnyhoney

My offer is to create a form online( based on landing page concept) for customers where the filled in data would directly be collected in a database ( online and in spreadsheet form). PMP, MBA and professional data More

$242 AUD in 10 days
(37 Reviews)
6.9
livegoodlife

A proposal has not yet been provided

$210 AUD in 3 days
(139 Reviews)
6.8
mrbrave

Thanks for inviting me to bid....I am available to discuss with you in detail...Please message me when you are available.

$155 AUD in 3 days
(153 Reviews)
6.1
best4best

Hi, I am an Excel expert. I can make the drop down list to show more options so you will not need to scroll down it. Regards Rav

$111 AUD in 2 days
(151 Reviews)
6.2
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready More

$122 AUD in 3 days
(90 Reviews)
6.1
d2imatrix

Hi, We are experts in excel. We have done several projects for our clients in data processing, reporting, dashboard designing, automation. Kindly let us know if you want to discuss further. Regards, Pal

$100 AUD in 5 days
(25 Reviews)
4.9
charleslimnet

I am an accurate and reliable business/Accounting/finance Analyst. I am a proficient business expert with over eight years writing experience. I have experience in Business plan writing, payroll, bank reconciliation, j More

$80 AUD in 3 days
(6 Reviews)
3.1
akrikun

Hello there. Both options are feasible. Option "a" will require Excel macro which will allow to have dropdown list with any amount of lines visible at the same time Option "b" - it would be better to discuss the det More

$83 AUD in 3 days
(7 Reviews)
3.2
viango

Hi there - my name is Ino. I read your brief and I can see that you need excel spreadsheet customized to speed up your quotation process. We can discuss about the price after you contact me. I am available to start More

$150 AUD in 5 days
(7 Reviews)
2.8
laurens23

I'm an aerospace engineer, currently staying at home to take care of my son. I'm looking for some things to do. I'm experienced in Excel and VBA and have made lots of templates, mathematical models and algorithms in More

$70 AUD in 3 days
(1 Review)
2.1
umeshrathod1982

Hello Sir, I can give you solution like this. You need to write 'YES' front of each items into the master sheet and when you run the macro then that will create a new TAB into the excel with the ready quotation. More

$250 AUD in 3 days
(1 Review)
1.8
vinzmalazarte

I am a fully dedicated Virtual Assistant for 2 yrs. I am capable in Internet Marketing, SEO, Wordpress, Social Media Marketing, Data Entry, Research, Audio and Video Transcribing and Video Editing. If you are looking f More

$155 AUD in 3 days
(0 Reviews)
0.0
twomedia

A proposal has not yet been provided

$94 AUD in 1 day
(0 Reviews)
0.0
rajnagaraj

A proposal has not yet been provided

$35 AUD in 2 days
(0 Reviews)
0.0
akhalyaa92

I have individual system with good internet connection. I am well versed in typing

$111 AUD in 3 days
(0 Reviews)
0.0
jainkhushi

A proposal has not yet been provided

$110 AUD in 6 days
(0 Reviews)
0.0
tzau

Hi there, just to share my views. In my honest opinion, I think you should invest in a dedicated software which can be run from your mobile devices and do not run the risk of getting modified. It would appear more More

$30 AUD in 0 days
(0 Reviews)
0.0
koganalexandra

A proposal has not yet been provided

$155 AUD in 2 days
(0 Reviews)
0.0