VBA Multiplication Formula

Hi, I wonder whether someone may be able to help me please.

The script below initially checks to see if there are any values in column B of a given page. If there are it applies a 'Sum' formula and creates a 'Totals' row on the next available row starting one column to the left.

Please Login or Register  to view this content.

I'd now like to add a second formula row, which will appear under the 'Totals' row, but only if it has been created. The formula I'd like to add is:

•Use the figure in the 'Totals' row multiplied by the figure in row 3 of the relevant column.

But I'm really not sure how to go about this.

I just wondered whether someone may be able to look at this please and offer some guidance on how I may go about achieving this.

Many thanks and kind regards

Hi,

I would like to help you, but I think I will need to see your workbook to fully understand the outcome that you are hoping to achieve. Could you please attach a desensitised copy of your workbook, including the macro that is supposed to run, and a detailed explanation of what value(s)/formula(s) you would like in which cells if which conditions are met (including an example of a correct outcome).

Uploading a workbook provides me a way to get you the correct answer faster, rather than guessing what it is that you want without seeing your code in context. I hope it's not too much hassle.

Thanks

Hi @AlphaFrog, thank you very muxch for taking the time to reply to my post, and for putting the solution together, it works great!

May I just ask please, how I can force both formula results to round to 2 decimal places?

Many thanks and kind regards

Hi @ajryan88, thank you for taking the time to reply to my post, it is grealty appreciated.

As you will see I've been fortunate enough to receive a solution from @Alphafrog, so I think this perhaps superceedes the need to attach my workbook.

Once again, many thanks for your time and kind regards

Hi @AlphaFrog, thank you very much for coming back to me so quickly. It's exactly what I was after.

Thank you form your time and trouble, it is greatly appreciated.

Kind Regards