Dynamic Validation using Table

[isarfraz]

On Excel 2007 Data Validation (with list) works dynamically with Table (list formatted as Table). I have noticed that it only works when Table and Cell on which validation is applied is on the same sheet. Does not work dynamically with addition / deletion in Table rows if it is not on same sheet. Any solution?

 

[xld]

Yes, on eof two way

1) name the cell on the other sheet and use that defined name in the DV

2) in the DV, reference the cell via INDIRECT, e.g. INDIRECT("Sheet2!A3")