My task is to list HVAC equipment serving each room of a building. The problem is, some rooms have multiple pieces of equipment, but each room should have it’s own “row”. If there is more than one piece of equipment serving a room, and a new row is inserted and the floor#, room#, and pressure cells are merged to appear as a thicker cell on the same “row” as both pieces of equipment. Can this be done easier with a macro or some other shortcut? Please see example screen capture video and example spreadsheet.

video: http://dl.dropbox.com/u/23864826/example_vid.mov

spreadsheet: http://dl.dropbox.com/u/23864826/EXAMPLE.xlsx