VBA to calculate share by brand by Retailer

[Dokat]

Hi,

I have a spreadsheet where i am trying to calculate share for each brand in different categories for various retailers via using VBA. Please see attached sample file.

for Walmart Share calculation should be

R3= Persil =L3/L2
R4= All =L4/L2
R5= Purex =L5/L2
R6= Sun =L6/L2
R10=Renuzit =L10/L9
R12=Combat=L12/L11
R14=Soft Scrub Abrasives=
L14/L13
R15= Soft Scrub Toilet= L15/L16

Basically for each retailer to calculate share Persil, All, Purex, Sun needs to be divided by HDD,
Renuzit divided by Air Care (EX DS)
Soft Scrub Abrasives divided by Abrasive Cleaners
Soft Scrub Toilet divided by Toilet Bowl Cleaners.

Is there an easy way to do this via VBA?

https://ufile.io/1oikv

Thanks

 

[Logit]

No easy way. Just using the formulas you have already provided.