Hello There,
I have a column (Invoice Number) in table. It has a Data Validation (DV) to prevent duplicate entry of Invoice Numbers as below:
=COUNTIF($A$2:$A$4,A2)=1
When I extend the table, this entry doee not work in the newly extended column of Invoice Number.
Is there a new way to write this formula in a Table column via Data Validation as well as in VBA? Attached a sample workbook
Could you please advise?
Thanks & regards
Don
I have a column (Invoice Number) in table. It has a Data Validation (DV) to prevent duplicate entry of Invoice Numbers as below:
=COUNTIF($A$2:$A$4,A2)=1
When I extend the table, this entry doee not work in the newly extended column of Invoice Number.
Is there a new way to write this formula in a Table column via Data Validation as well as in VBA? Attached a sample workbook
Could you please advise?
Thanks & regards
Don