I have a spreadsheet of building data,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
Thanks in advance