rkselby98
06-25-2008, 06:32 PM
In a check book ledger in Excel.
The first column is the check numbers - the column is set up with the formula A1+1 so with each entry it add the new check number for him.
Now he like to do a sort by Description or Who at times but when he does a sort the Check Numbers all change because of the formula and basically that column doesn't sort with the
Is there a way to get that column to "sort" with the rest and override the formula so the check numbers sort with the rest of the fields?
Sample file Attached.
Thank you and all have a great day and God Bless,
The first column is the check numbers - the column is set up with the formula A1+1 so with each entry it add the new check number for him.
Now he like to do a sort by Description or Who at times but when he does a sort the Check Numbers all change because of the formula and basically that column doesn't sort with the
Is there a way to get that column to "sort" with the rest and override the formula so the check numbers sort with the rest of the fields?
Sample file Attached.
Thank you and all have a great day and God Bless,