Grouping data from specific rows

**Goocharoo** · 06-27-2011, 06:09 AM

Hi, I have en excel 2003 worksheet that I use as an order book. I Have 9 columns and 999 rows, each row is a separate order and each cell contains data relating to that order such as date, supplier, item, cost etc. All my cells are pre filled with a colour so I type in an order and when the order is placed I manually clear the colour to white, this is so that I can easily see which orders I still need to place and which ones are completed.
I am trying to figure out a way to keep all the rows containing orders that are not placed together, (ideally at the bottom of the list) so that I can keep track of them easier, instead of having one at row 122 and another at 344 etc...
Grateful for any help,
Paul.

**Haseeb Avarakkan** · 06-27-2011, 06:25 PM

Hello Paul,

Insert a new column at the end of your data, say in Column L as Status & enter for all colored cell as Not Placed non colored cell as Placed. Then you can easily filter by Not Placed. If you are on XL2007 or later without inserting new column you can filter by colors.

If you want to see Not Placed orders as colored, use Conditional Formatting.

**Goocharoo** · 06-28-2011, 11:22 AM

Cheers Haseeb,
I have entered a tick in every cell in column 'L' then as an order is placed I simply delete it. I can then use the auto filter to show only the rows containing the tick. Similar principal to your suggestion.

Thanks for your help.