Sum Total and Validation Formula - VBA Code

[Guna13]

Hi Team,

I am Newibe for VBA Macro, How to Update Sum Total from "F3" to Dynamic Last column and Dynamic Till Last Row, also I need to update Validation Formula based "B" Column Values and above Sum Total VAlues same aspect, My Recording Macro didnt Support.

Sum Total Formual Screen Shot.

Validation Formula Screen shot.