Calculator needed

[bearingman]

I'm using Excel 2003 and need a little help creating a "calculator" for the guys in my workshop to use. It needs to be simple to use as none of us are experts in Excel.
Basically I have two lists of components, a component from List A is added to one from List B and a total in £'s needs to be shown, simple enough I hear you say HOWEVER the LENGTH of component B is variable.
For example
Input part # ABC in A1 and £50 is shown as a total in D1, then input part # 123 in B1 and the length of 100 in C1 and the total changes to £100. Then if you change the figure to 200 the total changes to £150

Any help would be appreciated it it's possible to do this?

[teylyn]

Hi bearingman,

welcome to the forum!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I'm sure if we can have a look at your data structure, a solution can be found in a zip!

[davesexcel]

Are the parts always in 50' increments?
Would a table work, so you could use Vlookup in the calculation?

[bearingman]

Teylyn
Heres an example of what i want/require

Again thanks for the help

[teylyn]

hi bearingman,

see the attached as a starting point. I've made drop-down lists for the components, to minimise data entry errors when entering component names.

I'm not quite clear what the meaning of the Qty Req'd columns is. Does that mean that there is a minimum oder amount, i.e. if I order Block B, I have to take two and can not take just one? If so, this has not been incorporated, but I'm awaiting your reply.

cheers

[bearingman]

Hi Teylyn
Wow! the reply came quick, how impressed am I?

Basically the guys will input a qty for each, there is no fixed qty, both the number of blocks and the length of the shaft are variable.

Thanks

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[bearingman]

Teylyn
Thank you so very much, the solution is excellent (please excuse the pun)
I should be able to icker with it a little, add drop downs etc.

Fantastic!