is it possible to somehow get and idea of how showing how much data has been entered and how much is missing and linking this to another sheet.

ive got my master which each department add to.

what i want is to make another table tracking the the physical amount of data given.

eg: asking ten people location, 6 people answer so in the other table i can say branch X has a return rate of 60% for location entering.


obviously im not working with just 10 entries, last count was over 4000 and across 28 fields.

thanks.