copy paste value of different cells to next empty cell in a given column

I have a sheet that will give me the pro-rated premium for endorsements to ins. policies ...
I want to set it up so if the insurance company assigns different annual premiums to the same client we can put those rates in different cells that could be double clicked to move that rate to the next empty cell in a particular column ... thought i could find a vba via dble click but so far no luck

so when I dble click on cells D3, E3, F3, H2 or H3 it would copy the value of the cell dble clicked to the next empty cell in column F .

anyone got this set up ?

If possible, could you be more specific on the exact actions you need to take place when those cells are double clicked?

copy the "value" (the dollar figure, not the formatting) to the next empty cell in col E sorry not col F

I put this code in the Sheet1 module of the VBA explorer, see how it works for you

Please Login or Register  to view this content.

+Attachment

yup PERFECT

thank you sooo much

You're welcome, anytime :D