G
Guest
Hi all.
I am working on creating a worksheet that keeps track of files and folders
that need to be routed. The files all have a number specific to a folder,
and so it makes sense for that to be the basis for orginization.
To save a lot of time trying to find folders that are jumbled together, I
wanted to find a way for Excel to alert me whenever a duplicate file number
is entered in a column. That way, I know when I can paper clip everything
together when it comes time to file, and I don't need to find the same folder
five times. I bet there is something with data verification I could do, but
I havn't found anything that works. If you know any way to do this, could
you post a tip for a poor newbie? Thanks!
Graham
I am working on creating a worksheet that keeps track of files and folders
that need to be routed. The files all have a number specific to a folder,
and so it makes sense for that to be the basis for orginization.
To save a lot of time trying to find folders that are jumbled together, I
wanted to find a way for Excel to alert me whenever a duplicate file number
is entered in a column. That way, I know when I can paper clip everything
together when it comes time to file, and I don't need to find the same folder
five times. I bet there is something with data verification I could do, but
I havn't found anything that works. If you know any way to do this, could
you post a tip for a poor newbie? Thanks!
Graham