Hi Guys I have setup a table where I will be entering data about a certain item. What I want to be able to do is once all of the table is filled i want to be able to transfer this data to a new worksheet and start filling the same table out with another item. I want to make this user friendly so I dont want to have to keep going to copy worksheet everytime I want to enter new data into the table but keep the old data as well, any answers would be greatly appreciated. Thanks.