Group rows Macro?

**BillXT** · 10-13-2008, 02:14 PM

Hello guys,

I got a question about how to make a macro that can group a set of rows from a complete list that are not been use in some related operations.

I attached a file with an example about it.

Thank you for your time regarding this issue.

**royUK** · 10-13-2008, 02:26 PM

I'm not too clear what you mean, but if you set the data out in a Table format then a PivotTable would be the best way

http://www.excel-it.com/pivot_tables.htm

**BillXT** · 10-13-2008, 02:45 PM

For example, in the attached file I have a Data Base with all cost of the different elements you need to build a house.

If i just want to build a house with a Slab and columns, i link the 2 items cost and get a total(My Budget). Now i will like to see just the Slab and Column cost and group/hide (no delete because is the Data Base) the other items that arent in use.

Hope you understand it better now.

**BillXT** · 10-13-2008, 04:26 PM

Here i wrote an example of how the code may be.

Is the attached picture

**royUK** · 10-14-2008, 04:03 AM

There is no sheet in the example that could be used as a database

**BillXT** · 10-14-2008, 11:18 AM

I am attaching again the workbook, the second sheet is how macro should look like.

I was building the code with the idea of the diagram i attached, i dont know if it is the best one, but still code isnt working.

Please if you can help me with it,

Thanks a lot.