Please help! Simple quoting system in excel

twostix

New Member
Joined
Dec 8, 2005
Messages
3
Hi there,
I'm new to Excel and have searched these forums for help but so far no luck. Therefore decided i'd register and ask for help! :biggrin:

I'm trying to build a simple variable data spreadsheet to help quote in digital printing.

So far i have a Stock Cost worksheet which lists a number of paper types and how much they cost per sheet.
I then have a Print Cost worksheet which has the click charge cost per sheet either single sided or double sided, black or full colour.

Now, this is the part i'm rusty on. I need to combine the data in a seperate sheet in order to calculate total cost per sheet (including stock and print cost) then need to have columns where i can add markup and quantity variables, and finally a subtotal cell which calculates all this.

The best way would be to have the fixed data (stock and print costs) in drop down menus (how do i do this?!) so that once selected, their relative values are incorporated into the final calculation.

Here is example of what i need...

'Dropdown Box for Stock' 'Dropdown Print Cost'
[Crusade Bond 135gsm (£0.05/sheet - hidden)] --- [£0.06]---------------


'Quantity' 'Markup' 'Subtotal'
[X*(0.05+0.06) =Y]------ [Y*Z%]-----------[=]



I hope this makes some sense!
Please please help! :wink: :wink:
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,118,529
Messages
5,572,657
Members
412,481
Latest member
nhantam
Top