Need to capture results automatically from one worksheet to another

[raygie]

Hey all, new to the forum and looking for help.

I've got two separate worksheets. The first one has data being created on a random basis, the results showing up in the same set of columns. Once the results are there, I'd like to copy them and paste them into another worksheet, capturing all the data.

Right now once the results are ready in the first sheet, I have to copy the row, go into the next worksheet and do a "paste special", selecting "values" and the data comes in. Then it's back to the first worksheet to change the conditions and get different results and do it all over again.

I'd like to find if there's a way to automatically send the results to the 2nd worksheet after the results are ready, and then the next results go into the next row and so on.

I hope I'm clear here but it's pretty time consuming the way I'm doing it and I'm talking about 600+ results that I have to capture and put into the new worksheet.