VBA to chose format from one column & speed from different column

[dinkss]

Hi there,

I have excel sheet data created with VBA, and simple dropdown menu list to chose different formats.
But I would like to have an option to select format and then the line speed for selected format would show on cell on top of it.

Is there any VBA code that I could use or a simple dropdown menu list or macro? Can anyone help?

I have attached screenshots of my excel and formats with speeds.

Any help will be much appreciated.

 

[dinkss]

I meant the formula that is return the #N/A

I only have in Q10 =SUM(C10:P10) and in Q12 =SUM(C12:P12). It works fine without vlookup but when I put vlookup SUM doesn't work

 

[dinkss]

I only have in Q10 =SUM(C10:P10) and in Q12 =SUM(C12:P12). It works fine without vlookup but when I put vlookup SUM doesn't work

It gives error because when I don't choose format or line speed it shows #N/A and SUM formula tries to calculate errors

 

[Fluff]

What is in C10:P10 & C12:P12?

 

[dinkss]

What is in C10:P10 & C12:P12?

In C10:P10 I have: =SUM(C12,C17:C32)
In C12:P12 I have: =IF(C14=0,"-",ROUNDUP(C15/C14,0))

 

[Fluff]

Ok, change the C12 formula to

=IF(C14="","-",ROUNDUP(C15/C14,0))

and copy across

 

[dinkss]

Also I'm trying to have a workbook with summary of all data which would take information from my first workbook. Is it possible to do this?
I mean I have excel file called BBK and new excel file Called SUMMARY, where I want to have data copied from cells eg: Q15 (where I have =SUM(C15:P15)) and cells Q17:Q32.

 

[Fluff]

Lets just stick with the current problem for now.

 

[dinkss]

Lets just stick with the current problem for now.

You are genius Man!!!! WOW!! Works perfectly!! Thanks so much!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[dinkss]

Also I'm trying to have a workbook with summary of all data which would take information from my first workbook. Is it possible to do this?
I mean I have excel file called BBK and new excel file Called SUMMARY, where I want to have data copied from cells eg: Q15 (where I have =SUM(C15:P15)) and cells Q17:Q32.

Can you help me with this one? Please?