I have an Excel question which I hope I explain clearly. I have a worksheet that has the first line as headings and then a ton of data. The data will se sorted by column A and then column B (column A contains building codes and column B is the floor number). Anyway, is there a way to "parse" the worksheet so that all the individual building codes (and all related data) plus the headings are copied/pasted into a separate worksheet within the same spreadsheet? So, if I have 50 different building codes I would like to result to be 50 separate worksheets in the spreadsheet each containing a specific building code with its data (plus the heading).

Does that make sense?

Thanks very much.