M
Mikey C
Hi all
I know this is probably something more suited to a database, but I
want to try add this functionality into an existing spreadsheet I
already use.
I have a worksheet for each customer which contains contact details
etc. What I have now done is included a section for notes & reminders
and have used conditional formatting to show any overdue tasks and
also to strike-out any completed tasks.
What I would really like to do is as follows:
1) I would like a way to sort all tasks so that any overdue
(highlighted in red) are pushed to the top of the list, with the
remainder sorted in date order (BUT ignoring the completed items,
which can be left at the bottom). Items are marked as complete by
entering either a "Y" or a "N" in a designated cell.
2) If at all possible, I would also like to have another sheet in my
spreadsheet which collects all the overdue tasks and displays them all
together.
I'm a bit of a numpty so please be gentle! Thanks for any help in
anticipation.
Mikey
I know this is probably something more suited to a database, but I
want to try add this functionality into an existing spreadsheet I
already use.
I have a worksheet for each customer which contains contact details
etc. What I have now done is included a section for notes & reminders
and have used conditional formatting to show any overdue tasks and
also to strike-out any completed tasks.
What I would really like to do is as follows:
1) I would like a way to sort all tasks so that any overdue
(highlighted in red) are pushed to the top of the list, with the
remainder sorted in date order (BUT ignoring the completed items,
which can be left at the bottom). Items are marked as complete by
entering either a "Y" or a "N" in a designated cell.
2) If at all possible, I would also like to have another sheet in my
spreadsheet which collects all the overdue tasks and displays them all
together.
I'm a bit of a numpty so please be gentle! Thanks for any help in
anticipation.
Mikey