recepkendir1
New member
- Joined
- Aug 13, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi Experts,
Subject: Action Item Spreadsheet(s)
Here is the basic Excel set up.
Column A, Status: Either "Open" or "Closed" will be written in these column cells. Any action items that are "Open" will need our attention and so we want them to go to the top of the spreadsheet . Any action items that have been dealt with as identified by the text "Closed" should drop to the bottom of the spreadsheet (after the list of Opens).
Column B, Priority: Either "High," "Medium," or "Low" will be written in these column cells. We want these to be tied directly to the "Open" items in column A. So, we want the "Open" items to sort so that high goes at top, medium under the highs and lows under the mediums.
There are also columns C, D, E etc, but we want the row data to all stay intact.
I need your help.
Subject: Action Item Spreadsheet(s)
Here is the basic Excel set up.
Column A, Status: Either "Open" or "Closed" will be written in these column cells. Any action items that are "Open" will need our attention and so we want them to go to the top of the spreadsheet . Any action items that have been dealt with as identified by the text "Closed" should drop to the bottom of the spreadsheet (after the list of Opens).
Column B, Priority: Either "High," "Medium," or "Low" will be written in these column cells. We want these to be tied directly to the "Open" items in column A. So, we want the "Open" items to sort so that high goes at top, medium under the highs and lows under the mediums.
There are also columns C, D, E etc, but we want the row data to all stay intact.
I need your help.