Hi excel people, I wonder if someone can give some tips for validating the completeness of my data ... here's my query:

sheet 1 is an input sheet and shows the sales units

sheet 2 is also an input sheet and shows sales prices

sheet 3 is a product of the two and should show calculated income

I say should because if sheet 2 is missing the price then the calculated income will be nil!

Any advice would be greatly appreciated.

Thx