What program are you opening it with. Is that Excel?
It only works in Excel for me, I have tried in some other Excel compatible apps (like Google sheets) but the macros etc don't all work.
There ar some icons that are not familiar to me in your screen shot, is it a mac?
Cell C6 on the main tab should contain the following function
=IF(ISBLANK($B6),0,VLOOKUP($B6,KITS!$A$3:$D$150,4,FALSE))
which means it grabs the weight from column D on the Kits tab.
Similar functions are used to calculate EBC, IBU, ABV etc though so if one part isn't working I would be surprised if any of it is.
It only works in Excel for me, I have tried in some other Excel compatible apps (like Google sheets) but the macros etc don't all work.
There ar some icons that are not familiar to me in your screen shot, is it a mac?
Cell C6 on the main tab should contain the following function
=IF(ISBLANK($B6),0,VLOOKUP($B6,KITS!$A$3:$D$150,4,FALSE))
which means it grabs the weight from column D on the Kits tab.
Similar functions are used to calculate EBC, IBU, ABV etc though so if one part isn't working I would be surprised if any of it is.