Quoting Spreadsheet - Microsoft excel

In Progress

We have a quoting spreadsheet created in-house. This system works reasonably well but very clunky and would like it smoother. We would like to streamline the data entry to the one page, all information can be fed into this page and then run through all connecting cells on each page. Is it easier to use drop down boxes to tick what items we want to input to help with the summary page (as below)

We want to then create a summary page which only shows each item used on each page - still in each section but showing materials, hours and machinery. This page will be used as our job costing page so we need the information entered into the spreadsheet as quoted and a column next to it as actual so we can determine profit and loss on each item.

Once the spreadsheet is completed we want it to be able to produce a adjustable gantt chart for the timeline of works allowed for in the quote.

Skills: Microsoft

See more: quoting excel spreadsheet, quoting spreadsheet, works need excel, n.c. machinery, microsoft excel spreadsheet, microsoft excel job, microsoft excel help 2013, microsoft excel help, house help job, spreadsheet microsoft excel, spreadsheet input, quoting, job costing, gantt, excel spreadsheet job quote, excel costing spreadsheet, data entry job in microsoft excel, excelchart, microsoft excel 2013, excel drop, shows profit, quote job excel, streamline spreadsheet, timeline gantt excel, create gantt chart excel

Project ID: #4675424

Awarded to:

FIBIN

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$200 AUD in 3 days
(3 Reviews)
3.1

7 freelancers are bidding on average $176 for this job

koolsidz

Excel whiz here ;) Please PMB

$223 AUD in 3 days
(10 Reviews)
4.1
nayabsiddiqi

i've provided you details in the freelancer inbox - please check

$200 AUD in 1 day
(3 Reviews)
3.3
JFCosta

I read your project requirements and i'm able to do it.

$100 AUD in 5 days
(0 Reviews)
0.0
spuliven

Interested. Please check PM.

$100 AUD in 3 days
(0 Reviews)
0.0
bmartynvw

Please read PM

$252 AUD in 30 days
(0 Reviews)
0.0
hbxfnzwpf

I am very proficient in vba, please let expert help you.

$155 AUD in 3 days
(0 Reviews)
0.0