i am working on a code to copy data from a loarge amount of data on a master worksheet and copy every 18,000 rows and place it on a new worksheet and then retrieve the next 18,000 from the master sheet and place it on a new sheet. i had the code to create the worksheet but am having trouble actually getting it loop and grab the next 18,000 without overlapping and copying the same data. anything ideas? let me know if anyone wants more clarification on the project.