Would auto number duplicate a value if a row is moved to a different sheet?

KevinHarrisCHT

Hello,

I currently have a sheet that assigns an auto-number value for each row. Upon certain actions taking place, this row then gets moved to a different sheet. Because that row got moved, would that free up that specific auto-number value to be used again? I am hoping not as we are looking to use this as a unique identifier.

TYIA!

Matt Lynn-PCG

@KevinHarrisCHT , no it will not. That originally used number will never be re used or re assigned if it's moved out of the sheet. No matter what, it'll always be the next sequential number from the last used, not the next that doesn't currently exist.

KevinHarrisCHT

Thanks so much @Matt Lynn-PCG!