Can the following Vba's be improved to run quicker.

hi now thats a nice piece of work

I do have one question

when I select a name with the dropdown menu on the summary page is there any way that the calculation could be smoother.

What I mean is that you can see the calculation occur.

It copy from the 1st row C3:D3 downwards and then shows the same in each row to C4:D50 whilst calculating

Is it possible not to see the calculation happen if you know what I mean

Originally Posted by Toonies

Is it possible not to see the calculation happen

In this solution, it is rather impossible, because when you select a name with the dropdown, in the first the sheet is calculation, and only then the macro is run.

But you can get rid of complex formulas. See attachment.

Artik

Your solution works a treat.

Can I ask where did you learn about VBA, have you got any good pointers or books that may improve my knowledge

Many thanks

Toonies