Search and Destroy

[gjadcock]

I have a spreadsheet of building data which has hundreds of rows (one for each room in the entire building), how can I create a VB script to check column A, which contains floor number (0,1,2,3...), and when the floor number changes insert two rows put a border around it insert text "Total" and then total column B for that floor and go to the next floor number. At he very bottom of the list I need another total for the entire building. I'm afraid I am new to this stuff and don't know any VB.

Thanks in advance

 

[Jim North]

Interesting subject line....

Look into PIVOT Tables or SUBTOTAL

 

[Ricky Morris]

You can accomplish this without using VBA, Try using Subtotals from the Data Menu.