Add value to master sheet from different sheet

[beneesetas14]

Sir

i am doing a project for performance in excel

i have Master sheet and two different sheet ( fire safety & scaffolding ).

i want to add values from each sheet ( fire & Scaffolding ) to Master sheet according to Year ,Month, Zone

Eg:

in Sheet " Fire "

after calculating total percentage ( Cell value :F30) , the value of F30 need to add on Master sheet according year, month, zone

similar from sheet "Scaffolding " value of F30 need to add on Master sheet according year, month, zone


Sheet " Fire "


if value of Cell F30 = 41.63%............................ the value of F30 need to add on master sheet cell no.D3

Sheet " Scaffolding"


if value of Cell F30 = 59.19%............................ the value of F30 need to add on master sheet cell no.D3




file attached

[xladept]

Hi Beneesetas,

I put them according to their year, month, zone

Please Login or Register  to view this content.