Excel/Small Program Document Help!

[Rasclart]

I am shi.t with Excel & programming/equations

Basically I need to create a Spreadsheet which includes a Box where you can select between two cable types (With different prices per M), then a required length, then the choice of 4 connectors from a drop down box and then have it all calculated into one price.

Can be done in Excel or as a standalone App in something like VB as the unit prices will not need updating anytime soon

Can anyone make this for me? Quite willing to pay someone for there troubles via Paypal.

Send me a PM if you can help

 

[Revels]

Re: Excel Document Help!

MarkCup is an excel guru.

Try him, tractor boy.

 

[Rasclart]

I shall PM him. Cheers butter

 

[iain187]

http://www.sendspace.com/file/2jf92a


is that what you need? you should be able to change the names and prices without buggering it up. You could also add more cables and connections if you wish to tinker with the formulas


if you want to hide all the values once you have set the names and prices up just set the font to white


I presume there is a formula i dont know to do that more easily but meh it works

 

[Rasclart]

Just seen this post sorry. Thats *****tastic will do the job nicely Thank you for that

 

[Rasclart]

Quick one how do I edit the Values and cell names for each drop down?

 

[KDF]

The values are taken from the cells below.

 

[Rasclart]

LOL just figured that out. Dickhead I am

Cheers boys

 

[iain187]

lol and if you get a pm back saying another way to do it post it up here and share the wealth, im sure my way isnt the easiest but it works!