Hi All,
Inside my sheet2 got a column called ID.
Whatever dataID entered in sheet1 will be transfer to sheet2 column ID.

Previous i have old records inside sheet2 already. For example, 0009 is
already inside sheet2 column called ID.

Now,the ID in sheet1 is created by auto-increaseing value of 1. And will
start all over again. For example start from 0000. It will become 0001 follow
by 0002.
When the 9th records has to be created, it will produce 0009. But 0009 is
already inside sheet2 long ago.

How can i prevent that, 0009 from created? Any helps? Thanks!