Hopefully I can describe the macro I am trying to create, accruately. I have a report that dumps data into excel. The data becomes one long worksheet. I would like to design a macro that will divide the data into multiple worksheets. The data in column A is the determining factor as to which spreadsheet the row should go to. Any ideas? I am sure this will take additional explanation.