I have a list data in in Sheet1 from A1 to J25; A1: J1 is Header row and Cell value in A2 to J25 are actual data; I want to generate 24 separate workbooks one for each set of data i.e. each new Workbook Sheet1 should have in its first row the header values of A1:J1 of my main workbook and in second row the data values A2:J2 for first new workbook, A3:J3 for second workbook, A4:J4 for third workbook and so on. I would appreciate if any one could please suggest a vba sub routine for this.