I want to perform validation for the following
Sheet 1
Col A (reference)
Col B
Col C
Col D
etc.
Summary sheet
if there is is a number/character missing in sheet 1 for example for property ref 1 colA costs and colB costs are missing
The summary sheet to automatically display the reference num and the associated column names missing
Property Reference Missing data items
1 Col A
1 Col B
1
4
etc
I highly appreciate if you could provide me with some solutions
Sheet 1
Col A (reference)
Col B
Col C
Col D
etc.
Summary sheet
if there is is a number/character missing in sheet 1 for example for property ref 1 colA costs and colB costs are missing
The summary sheet to automatically display the reference num and the associated column names missing
Property Reference Missing data items
1 Col A
1 Col B
1
4
etc
I highly appreciate if you could provide me with some solutions
