% of OI and % of vol
 

find %-of-change-in-oi
compared to OI of that strikeprice
to total OI(sum b4: b16 for calls and h4:h16 for puts)
( should be for that strike-price only)
---in n18-n19-n20 and r18-r19-r20

finds %of vol of
that strike compared to total volume(sum d4:d16 for calls and
sum(f4:f16 for puts) ,
---in o18-o19-o20 and s18-s19-s20

Am attaching an excel file where I have mentioned as to what is the
problem. Please help me to solve. Also this is one table but
originally this has to be copied in such 200+ tables , so please if
possible , find the solution using relative referencing.

here xlsx file is not allowed to be uploaded .
dropbox link of that is
https://www.dropbox.com/s/h53nfk4l98...blem.xlsx?dl=0

Zohar