Thanks for the reply Jindon, the code works great but is there away to also copy the header (row 1) from the original worksheet into all the other sheets at the same time? Similar to the other thread code "FirstRow = 2 'headers in row 1" kind of thing. Thanks again