Formula Help

[Abhisek4]

I need to check if the data in the cells A to D are complete and correct for all the sheets in excel and get the output populated in a separate sheet.

[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl67, width: 64"]A[/TD]
[TD="class: xl67, width: 64"]B[/TD]
[TD="class: xl67, width: 64"]C[/TD]
[TD="class: xl67, width: 64"]D[/TD]
[/TR]
[TR]
[TD="class: xl67"]Name[/TD]
[TD="class: xl67"]Age[/TD]
[TD="class: xl67"]DOB[/TD]
[TD="class: xl67"]Date of graduation[/TD]
[/TR]
</tbody>[/TABLE]


Can I use Excel VBA code for this? If yes, what would be the code?

Thanks in advance!

 

[SteveO59L]

what are you checking against. and what do you want in a separate sheet?