Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Converting a grid to a list

Posted by Annette on September 14, 2000 1:57 PM

I have a lovely summary grid of groups and what projects each is involved in.

Now the request is an individual list for each group, listing only their projects.

Example grid:
Project A Project B Project C
G1 X X
G2 X X
G3 X

I can create the list easily enough with an IF..THEN statement, but I'd get blank lines
for the projects that are "skipped" in each row...

Thanks!

Re: Converting a grid to a list

Posted by Scott H on September 14, 0100 4:38 PM

Try using the autofilter function on the grid. Go to Data>Filter>Autofilter. What you see is a drop down arrow in each cell across the top of your grid. Click on the arrow in the group name column and select the group you need. The result is the other rows are hidden entirely from view.

You can even copy and paste multiple rows (without the hidden ones!)

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.