How do I put worksheets in alphabetical order

I have created a database which has been worked on by someone else.

I have made the necessary alterations but how do I check for duplicate
entries on each worksheet.

Thansk

Take a look at

http://cpearson.com/excel/duplicat.htm


In article <F87E0D91-E192-42EC-A8BA-E1FEC70CCB6E@microsoft.com>,
"DLee" <DLee@discussions.microsoft.com> wrote:

> I have created a database which has been worked on by someone else.
>
> I have made the necessary alterations but how do I check for duplicate
> entries on each worksheet.
>
> Thansk

First you need two helper columns -
One column to give each row a number - so that you can at least get it
back to the same order as it started.
One column to contain a formula =IF(a2=a1,1,0) (where column A is
suspected to have duplicated cells)

Sort on the suspicious column

Find any incidents of 1 in the second helper column. This indicates a
duplication.

Regards.

Bill Ridgeway
Computer Solutions

"DLee" <DLee@discussions.microsoft.com> wrote in message
news:F87E0D91-E192-42EC-A8BA-E1FEC70CCB6E@microsoft.com...
>I have created a database which has been worked on by someone else.
>
> I have made the necessary alterations but how do I check for duplicate
> entries on each worksheet.
>
> Thansk