Data Validation not working,for excel validation Please Help!!!

Hi All,

Please, I need help with the data validation for the column A (BCR #) for generating sequential numbers starting from 1 to 20,000 for spreadsheet validation. This excel spreadsheet is used to assign numbers. I am validating this spreadsheet to prevent duplicates numbers being assigned.

At the moment, when i use the fill icon to drag the number above to the next cell, data validation will not work. It still accepts the same number.
For instance, when i assign "1" on cell A2 and drag this to cell A3, it automatically gives drags the number 1 into the next cell A3 without enforcing the data validation that was set up to prevent this duplicates. Also, when i manually type in 1 on cell A3, I will get a prompt that no duplicates allowed.

Question, is how to prevent the fill icon from dragging into the next cell. See the attached spreadsheet.

Please, can someone help and let me know what i did wrong.

Many Thanks!
Angel

Hi Glenn,

I had thought i had the excel sheet attached. Where is the "upload" or attachment button" for attachment in the forum? I seem not to have see the button. Please, let me know and I will attach this again.

Many Thanks!
Lovina

Hi All,

Please,see the spreadsheet attached and the problem is with column A accepting duplicates using the fill drag icon while data validation is in place.

Many Thanks!
Angel.

Hi FDibbins,

Thanks for your response. I tried this again, the number above the cell was dragged down into the next cell and the Data validation did not recognize this as duplicate. Is there any way, I can set the data validation so that dragging the cell value above will automatically increment instead of retaining the previous number?

Many Thanks!
Lovina