Valdiation to follow cell after sorting.

Heya folks.
New to this forum and excel manipulation.


What I have is a basic name/telephone number spread sheet.
All data is entered on the INFO sheet
The validation is entered into the cells on LISTS sheet

I have it to where sheet #2 (LISTS) takes the info from sheet #1 (INFO) and re-lists the data by phone number in column B, and the same data alphabetically in column E.

Under the INFO / NAME column i entered data validation.

On the LISTS sheet, I would like if the validation would follow it's assigned cell after you sort column B or D.

Thanx!



Attachment 202068

this is going to be an issue - since my terminology is limited for excel discussions.
but here it goes....

When DV is added to a cell, (say B2 for Bob Smith),
When Bob Smith is relocated to another cell due to sorting, I want the DV to follow Bob Smith, not stay with cell B2

To answer SixthSence
Im tried selecting the column and also selecting a range of cells, I get the same results - the validation remains in the original cell it was assigned to, it will not follow the data. - if that makes sense

To Answer FDibbins....
In the example sheet Ive included....
On sheet LISTS..... in column D (list by name) I added validation to cell D4 (Susie Jackson)
When either D3 thru D7 (or the entire D column) is selected for sorting...the validation will not follow Susie Jackson,.. the validation remains at cell D4.

So - when D3 thru D7 is selected to A - Z sorting.....Kevin Harper now becomes D4 - but validation for Susie Jackson remains at D4

I would like the validation to remain with Susie Jackson whenever she may wind up after said sorting.


If improved terminology is required - please direct me to the nearest Terminology-Fer-Dummys page.