Need some help with my code

[gav_69]

Hi,

Could sombody please help me. i need a hand adding in some code to the macro i wrote. All i have left to add is highlighted in red on the right hand side of the sheet. Its for insurance quotes.

I might of taken the long way around but it was the only way I could think how to do it.

I have attached the file. I think i have everything else accounted for. Or if somebody has an easier way that would be great.

Thanks for any help

[Carim]

Hi,

What you have done is already very good ... Congratulations ...

Transforming your code into a function would simplify things ... i.e a user input would automatically trigger the cost ...

Now, I do not fully understand what you are actually missing ...

[gav_69]

Hi Carim,

Thanks for the reply

How would i actually go about changing the code into a function. In my code i didnt account if the cover was TPFT. So i select TPFT cover its not giving me the correct quote, i can figure out how to add it in. Any ideas, i have tried to use index and match functions but cant seem to get it to work.

[Carim]

Hi,

As far as TPFT cover is concerned, you should have no difficulty at all including it into your existing code ...

Regarding transforming your macro into a function, take a look at a quick and dirty draft (just a copy of your code...for a starting point) used in cell N7 ...