hi,
My requirement is to check whether the review sheets are complete.Certain
columns should be filled after review,both by the reviewer and the one
whose work is being reviewed.
my input is an excel sheet with a column containing the name of the review
sheets.

My macro should open these sheets one by one and check whether those
columns are filled properly,if not indicate by some means.

to automate the manual checking whether the review sheets are completely
filled..

i need a macro for this